Wakelin Solutionz Pty Ltd

SPECIALISTS IN PERSONAL & ORGANISATIONAL PRODUCTIVITY

Phone: +61 421 551 254      Email:  wakelinsolutionz@bigpond.com

Hot Tips

Excel

• Select the visible cells on a worksheet (e.g. after using filter, or subtotals)

• Limit what a user enters in a cell

• Stop a user pasting invalid information into a cell containing data validation

• Get a list of unique values from a particular column

• When printing, change where the page breaks

• Print the same column on the left of each page

• Use Advanced Filter to copy information to another worksheet

• Centre a heading across a number of columns

• Avoid the #DIV/0! error occurring

• Avoid entering the date in more than one place by linking headings and cells to one particular date

Return to top