I'm an Excel newb, so hopefully this can be answered easily.
How do I save only the relevant information in a spreadsheet so I don't see all the junk to the bottom and to the right when I open the worksheet?
Thanks in advance!
I'm an Excel newb, so hopefully this can be answered easily.
How do I save only the relevant information in a spreadsheet so I don't see all the junk to the bottom and to the right when I open the worksheet?
Thanks in advance!
Delete the junk, and then save it.
If it's not truly junk, you can hide the rows and columns using Format > Row > Hide and Format > Column > Hide commands from the Excel menu.
HTH
Jason
First of all
http://www.excelforum.com/showthread.php?t=591596
and what to you mean by junk at the bottom?
oldchippy
-------------
![]()
![]()
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Sorry man, I just needed some help in a hurry for something and didn't read all the important info I guess.Originally Posted by oldchippy
Junk at the bottom = all the unused rows/columns.
Thanks, and sorry again.
OK, to clear unused rows or columns, go into the next blank column, then press Ctrl+Shift+Right Arrow, with all the columns selected, right click > Hide. Do the same for rows but use the down arrow.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks