Tags » Microsoft Excel 2010

Microsoft Excel – referencing last row in a worksheet from another worksheet using OFFSET

What if you want a worksheet that references the last row in another worksheet which will update itself automatically as the number of rows in the worksheet changes? 358 more words

Microsoft Excel

Saving an entire Excel workbook to a pdf

By default if you save from Excel to pdf, it just saves the worksheet you currently have selected. However, you can save the whole workbook as one pdf. 149 more words

Microsoft Excel

Microsoft Excel – entering weekdays into a worksheet

In Microsoft Excel, if you type in Monday, you can then use the Autofill handle to enter the rest of the days of the week. If you carry on dragging down, it will start again at Monday. 95 more words

Microsoft Excel

Microsoft Excel - comparing two columns of figures using conditional formatting

Suppose I have sales figures for two years and I want to highlight this year’s figures in green if they are higher than last year’s figures and in red if they are lower than last year’s figures. 125 more words

Microsoft Excel