Hi. Help. Please.
I have somehow ended up with extra columns and rows in my spreadsheet that go on into infinity and make it unprintable. They . How can I do a "delete all columns to the right of... and deleted all rows below..."?
Thanks.
Hi. Help. Please.
I have somehow ended up with extra columns and rows in my spreadsheet that go on into infinity and make it unprintable. They . How can I do a "delete all columns to the right of... and deleted all rows below..."?
Thanks.
Adjust your print settings.
Go to view--print preview, see the print area and adjust accordingly by dragging the lines
Life's a spreadsheet, Excel!
Say thanks, Click *
are you saying go to the view tab because if so, there isn't a print preview there. when I go to print preview, don't have the drag option. what a I missing?
Oops..I meant page break preview!
That is fine for printing, but I want to delete all of this extra space. Any ideas?
this led me to think, it was a printing problem.I have somehow ended up with extra columns and rows in my spreadsheet that go on into infinity and make it unprintable
Select the blank rows/columns right click and delete.but I want to delete all of this extra space. Any ideas
Does this work?
apologies for the confusion. I guess that's what I am asking. How do you select infinity?
added: i have been scrolling, highlighting, deleting and it doesn't help.
Once you have selected your first non-functional (blank) row of the rows you want to delete press Ctrl+Shift+Down arrow keys to select till the last row (infinity!) -- then delete
Similarly, for columns on selecting your first non-functional (blank) column press Ctrl+Shift+Right arrow keys to select till last column (infinity!) -- then delete
If this does not work, upload a sample workbook
That's it! I knew it was something painfully obvious. Thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks