How do you stop the screen from moving

abz2max · Apr 17th, 2002, 07:40 AM

Excel sheets are really big, so is there a way to stop the screen from moving into the unwanted regions of the spreadsheet.

lenze · Apr 17th, 2002, 07:53 AM

You can decrease the size of a worksheet by hiding unwanted rows and columns. Say you only need columns A - J. Select column K and then enter Control-Shift-Right to select all columns to the right. Right-Click and choose hide. Use Control-Shift-Down to select and hide rows below your work area.

HTH

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 17th, 2002, 07:40 AM	#1
abz2max New Member Join Date: Apr 2002 Posts: 19	Excel sheets are really big, so is there a way to stop the screen from moving into the unwanted regions of the spreadsheet.

Apr 17th, 2002, 07:53 AM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	You can decrease the size of a worksheet by hiding unwanted rows and columns. Say you only need columns A - J. Select column K and then enter Control-Shift-Right to select all columns to the right. Right-Click and choose hide. Use Control-Shift-Down to select and hide rows below your work area. HTH