Tags » Microsoft Excel 2010

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

Removing blanks from credit card entries in Microsoft Excel

I was asked recently how to get rid of blanks in credit card entries within an Excel worksheet, e.g 1000 2000 3000 4000 should read 1000200030004000. 114 more words

Microsoft Excel