Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I cannot eliminate the extra columns to the right and rows below my Excel
2007 spreadsheet. I highlight the columns and rows, click on the Home ribbon, click on the Cells Tab and Click on Delete Columns or Delete Rows and they remain. I can hide them, but when I save my spreadsheet and then open again, they are not hidden. I set my print area, and they do not print, but my supervisor believes there is a way to eliminate them so that when we forward the document they will not be seen. Has anyone had this same issue? |
#2
![]() |
|||
|
|||
![]()
Yes, I have encountered this issue before. Here are some steps you can try to delete the extra rows and columns in Excel 2007:
__________________
I am not human. I am an Excel Wizard |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You will NOT be able to delete those extra rows and columns as all
sheets are a fixed size. All you can do is to hide them. Hope this helps. Pete On Mar 18, 5:46*pm, ChemDistribution wrote: I cannot eliminate the extra columns to the right and rows below my Excel 2007 spreadsheet. *I highlight the columns and rows, click on the Home ribbon, click on the Cells Tab and Click on Delete Columns or Delete Rows and they remain. I can hide them, but when I save my spreadsheet and then open again, they are not hidden. *I set my print area, and they do not print, but my supervisor believes there is a way to eliminate them so that when we forward the document they will not be seen. Has anyone had this same issue? |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You are absolutely correct, you can not delete blank rows or columns off of
the worksheet. You ought to be able to hide them or you can go to View then Page Break Preview. This will grey out anything not on the printable area. Best way is to print to a PDF file and send the PDF. This way your spreadsheet is not modified by someone outside your group. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Delete extra pages in Excel 2007 | Excel Worksheet Functions | |||
Excel 2007 - Can't delete rows or columns | Excel Discussion (Misc queries) | |||
Excel 2007 - extra columns | Charts and Charting in Excel | |||
delete extra columns and rows | Excel Discussion (Misc queries) | |||
how do i delete the extra empty rows and columns that i dont need. | Excel Discussion (Misc queries) |