Monthly Archives: November 2017
Change Prices or Values on Spreadsheet without using Formulas
If you have an Excel spreadsheet with lots of values and you want to change them all very quickly then watch this video. You can add, subtract, multiply or divide all the values in one go.
Remove Page Break Lines in Excel
This video explains how to remove those really annoying page break lines on an Excel worksheet using one line of VBA code. Any level of user can do this.
Sub PrintLines() ' 'Removes page break dotted lines 'Create in Personal Macro workwook 'PERSONAL.XLSB 'Place link in Quick Access Tool Bar ' 'InITLearning.net ' ActiveSheet.DisplayPageBreaks = False End Sub