| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 showing empty rows at bottom
I have an excel sheet which has about 200 rows of data. When I pull the
scroll bar down, it goes down to row 385. These extra rows don't have data in them. How can I set it so the scroll bar only pulls down to one row after the last row of data? -- Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2007 showing empty rows at bottom
Simply Select and Delete rows after your data down to row 385. Not
"Clear contents", but r-click, Delete. Saucer Man wrote: I have an excel sheet which has about 200 rows of data. When I pull the scroll bar down, it goes down to row 385. These extra rows don't have data in them. How can I set it so the scroll bar only pulls down to one row after the last row of data? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2007 showing empty rows at bottom
.... then save, close, and reopen.
-- David Biddulph Bob I wrote: Simply Select and Delete rows after your data down to row 385. Not "Clear contents", but r-click, Delete. Saucer Man wrote: I have an excel sheet which has about 200 rows of data. When I pull the scroll bar down, it goes down to row 385. These extra rows don't have data in them. How can I set it so the scroll bar only pulls down to one row after the last row of data? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Totals Not Showing At Bottom Of Excel Window | Excel Discussion (Misc queries) | |||
| What produces empty rows at the bottom of a spreadsheet? | Excel Discussion (Misc queries) | |||
| unwanted empty rows at worksheet bottom | Excel Discussion (Misc queries) | |||
| Stop excel icon showing at the bottom when opening spreadsheets | Excel Discussion (Misc queries) | |||
| empty rows at bottom of worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
