PDA

View Full Version : Excel 2007 problem.



Bryan
04-04-2010, 10:42 AM
I have a single page of data but I seem to have somehow created a nightmare in incorporating the whole page of possible cells IE. 1 to who knows what, 100,000? and A to ZZ.

How can I easily revert back to a single page again?

TeejayR
04-04-2010, 12:22 PM
You can delete complete columns by selecting e.g. column G then selecting Ctrl-Shift Right Arrow then right click and delete.

You can do the same for rows by selecting a row then Ctrl-Shift Down Arrow and right click delete - or have I misunderstood your problem,

coldot
04-04-2010, 12:25 PM
Maybe you pressed Page Down or End.
Check that you haven't entered any stray characters/numbers in the vast space.
But if the cells are all empty beyond your 'real' data, it shouldn't be saving all the empty ones in the file. If you want to print only your data then select Page Layout/Print Area to specify.

Bryan
05-04-2010, 07:53 AM
TeejayR thank you.