300 office tips • Special feature Microsoft Excel 75 tips and tricks for your favourite spreadsheet. Convert rows to the running total of the figures in A1 to Pick the function you require from the 1columns A5 in the adjacent column. list box and click on OK. Now You can convert rows to columns (and highlight the cells on which you want columns to rows) by highlighting the Remove hyperlinks the target to perform the function and cells you want to switch around, 5from your work click on OK. clicking on Edit, Copy, selecting a new If Excel has already converted your cell and then going to Edit, Paste written URL into a hyperlink, you can Special… Finally, place a tick in the cancel it by right-clicking on the Transpose box on the dialog box and offending address and selecting click on OK. Hyperlink, Remove Hyperlink from the menu that pops up. Calculate time 2between dates Fit wide tables to the Enter in a cell the formula =A2-A1, 6page width where A1 is the earlier date, and A2 To make your tables fit neatly on the the later one. Don’t forget to convert page, click on File, Page Setup…, the target cell to number format – do select the Page tab, click on the Fit to: this by highlighting the cell, clicking on radio button and pick 1 page wide. Format, Cells…, picking on the Click on the tall box and press Number tab and selecting Number [Delete], leaving t
