Monitor your printout size from anywhere in Excel 2007/10: On Page Layout tab, right-click on Scale, then Add to Quick Access Toolbar.
Tag: Excel
Dec 12
Managing The Recent Files Menu
Excel 2010: Right-click to remove a file or folder from the Recent menu. Earlier versions? Set number of files to 0, but kills entire list.
Nov 29
Unscrollable Worksheets
Can't scroll your Excel worksheet? Excel 2007/10: Choose View, Freeze Panes, then Unfreeze Panes. Excel 2003: Choose Window, Unfreeze Panes.
Oct 25
Table Feature
Excel 2007/2010: Choose Insert, Table, and then click Total Row on the Design tab to make staid lists of data interactive.
Oct 06
Recovering Unsaved Workbooks
Accidentally close a spreadsheet without saving? In Excel 2010 choose File, Info, Manage Versions, and then Recover Unsaved Workbooks.
Sep 15
Format Painter Trick
Double-click Format Painter (paintbrush icon) to transfer cell formatting to multiple non-contiguous cells; press Escape when complete.
Aug 24
TODAY() Versus NOW()
TODAY() returns a date, while NOW() gives a date AND time. For best results use TODAY in formulas that compare today's date to a date range.
Jul 18
Converting Text To Numbers
Does your Excel spreadsheet contain numbers stored as text? Select the numbers, choose Data, Text to Columns, and then click Finish.
Apr 19
Rounding Tricks
Rounding tricks: =MROUND(331,25) returns 325; =CEILING(331,25) returns 350; =ROUND(9865,-3) returns 10,000 (rounds to nearest 1000)
Feb 11
Free Clipart For Excel
Need free clipart for your Excel spreadsheets or other documents? Microsoft offers a huge library at www.office.com/clipart
Jan 21
Best Format For Clipart
When inserting graphics into an Excel worksheet, make sure to use the BMP format, particularly as opposed to the PNG format.
Sep 09
N() Function
The N() function allows you to embed notes within formulas, e.g. =SUM(A1:A5)+N(“Sums rows 1 through 5”). N evaluates to zero.
Jul 27
Moving Columns Trick
To move selected columns, hold the Shift down while you move the edge of your selection with left mouse.
Jul 23
Undo Comparision
Excel 2007/10 tip: Press Ctrl-Z repeatedly to undo your last 100+ actions. Even better, you can still undo actions after you save your file. In Excel 2003 and earlier you can only undo the last 16 actions, and saving your file clears the undo stack. You cannot undo renaming a worksheet name or deleting a worksheet in any version of Excel
Jan 05
Trick For Hiding Rows
In Excel 2007, save a couple clicks when hiding rows or columns: choose Format, Row Height or Column Width, and enter 0.