Size of worksheet

Resolved · Low Priority · Version 2003

Wed 24 Mar 2010, 16:33 Delegate Alex said...

Alex has attended:
Excel Intermediate course
Excel Advanced course
Excel Advanced course

Size of worksheet

How do you reduce the size of the available worksheet?

Thu 25 Mar 2010, 16:47 Trainer Anthony said...

RE: Size of worksheet

Hi Alex, thanks for your query. I think we cracked this one after the class. Simply hide the unwanted columns and rows!

Hope this helps,

Anthony

Excel tip:

Turn Function tooltips on and off

Excel 2002 (XP) and Excel 2003 have the Function tooltips facility. When you type in a function name followed by a bracket, for example, =IF(, a yellow box appears beside the function name and lists the function's arguments. This is very useful when you can't quite remember the order of a function's arguments or what the arguments actually are!

However, Function tooltips can become annoying. To turn them off, choose Tools|Options. and select the General tab. Then, untick the Function tooltips box and choose OK.

View all Excel hints and tips

Size of worksheet

Size of worksheet

RE: Size of worksheet

Excel articles

Excel tip:

Turn Function tooltips on and off