Excel Tips(1).pdf

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