Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Delete gridlines and shading below
Hi Everyone,
Someone sent me an excel sheet and they selected the whole sheet and put borders on all cells. They also shaded columns all the way down. I have 72 pages but only want one. I need to keep the borders and shading on cells A1-AG40. I tried to delete the rows by selecting for 41 and dragging down but I got to 50,000 rows and there were still more. How can I clear the contents of everything below row 41 and keeping everything above intact? Thanks, Linda |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Delete gridlines and shading below
Click in the name box (above column A's header), type A41:IV65536
press enter, then select EditClear if there is data that you want to keep and just remove the format select formats if there is no data just formats select all press Ctrl + Home and save the workbook -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "LMB" wrote in message ... Hi Everyone, Someone sent me an excel sheet and they selected the whole sheet and put borders on all cells. They also shaded columns all the way down. I have 72 pages but only want one. I need to keep the borders and shading on cells A1-AG40. I tried to delete the rows by selecting for 41 and dragging down but I got to 50,000 rows and there were still more. How can I clear the contents of everything below row 41 and keeping everything above intact? Thanks, Linda |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Delete gridlines and shading below
Is the name box the fx field? I typed that in cell A 41 also but it didn't
work. "Peo Sjoblom" wrote in message ... Click in the name box (above column A's header), type A41:IV65536 press enter, then select EditClear if there is data that you want to keep and just remove the format select formats if there is no data just formats select all press Ctrl + Home and save the workbook -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "LMB" wrote in message ... Hi Everyone, Someone sent me an excel sheet and they selected the whole sheet and put borders on all cells. They also shaded columns all the way down. I have 72 pages but only want one. I need to keep the borders and shading on cells A1-AG40. I tried to delete the rows by selecting for 41 and dragging down but I got to 50,000 rows and there were still more. How can I clear the contents of everything below row 41 and keeping everything above intact? Thanks, Linda |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Delete gridlines and shading below
The name box is left end of the formula bar.
Another method is to go to row 41. Select entire row and SHIFT + End + DownArrow. EditDeleteEntire Row. Do same for columns to the right of AG IMPORTANT step. Save the workbook at this point. Older versions required a save/close /reopen to see the changes. Gord Dibben MS Excel MVP On Wed, 4 Oct 2006 07:54:36 -0400, "Linda RQ" wrote: Is the name box the fx field? I typed that in cell A 41 also but it didn't work. "Peo Sjoblom" wrote in message ... Click in the name box (above column A's header), type A41:IV65536 press enter, then select EditClear if there is data that you want to keep and just remove the format select formats if there is no data just formats select all press Ctrl + Home and save the workbook -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "LMB" wrote in message ... Hi Everyone, Someone sent me an excel sheet and they selected the whole sheet and put borders on all cells. They also shaded columns all the way down. I have 72 pages but only want one. I need to keep the borders and shading on cells A1-AG40. I tried to delete the rows by selecting for 41 and dragging down but I got to 50,000 rows and there were still more. How can I clear the contents of everything below row 41 and keeping everything above intact? Thanks, Linda |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Delete gridlines and shading below
That was it! Select Row, then Shift+end+down
I see where your 65536 came from....I guess you have 65536 rows in excel. Thanks a million! Linda "Gord Dibben" <gorddibbATshawDOTca wrote in message ... The name box is left end of the formula bar. Another method is to go to row 41. Select entire row and SHIFT + End + DownArrow. EditDeleteEntire Row. Do same for columns to the right of AG IMPORTANT step. Save the workbook at this point. Older versions required a save/close /reopen to see the changes. Gord Dibben MS Excel MVP On Wed, 4 Oct 2006 07:54:36 -0400, "Linda RQ" wrote: Is the name box the fx field? I typed that in cell A 41 also but it didn't work. "Peo Sjoblom" wrote in message ... Click in the name box (above column A's header), type A41:IV65536 press enter, then select EditClear if there is data that you want to keep and just remove the format select formats if there is no data just formats select all press Ctrl + Home and save the workbook -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "LMB" wrote in message ... Hi Everyone, Someone sent me an excel sheet and they selected the whole sheet and put borders on all cells. They also shaded columns all the way down. I have 72 pages but only want one. I need to keep the borders and shading on cells A1-AG40. I tried to delete the rows by selecting for 41 and dragging down but I got to 50,000 rows and there were still more. How can I clear the contents of everything below row 41 and keeping everything above intact? Thanks, Linda |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Delete gridlines and shading below
Thanks for the feedback.
For more Excel info go to Help and type in "specifications" to get a list of limits and sizes etc. Gord On Wed, 4 Oct 2006 19:41:20 -0400, "Linda RQ" wrote: That was it! Select Row, then Shift+end+down I see where your 65536 came from....I guess you have 65536 rows in excel. Thanks a million! Linda "Gord Dibben" <gorddibbATshawDOTca wrote in message .. . The name box is left end of the formula bar. Another method is to go to row 41. Select entire row and SHIFT + End + DownArrow. EditDeleteEntire Row. Do same for columns to the right of AG IMPORTANT step. Save the workbook at this point. Older versions required a save/close /reopen to see the changes. Gord Dibben MS Excel MVP On Wed, 4 Oct 2006 07:54:36 -0400, "Linda RQ" wrote: Is the name box the fx field? I typed that in cell A 41 also but it didn't work. "Peo Sjoblom" wrote in message ... Click in the name box (above column A's header), type A41:IV65536 press enter, then select EditClear if there is data that you want to keep and just remove the format select formats if there is no data just formats select all press Ctrl + Home and save the workbook -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "LMB" wrote in message ... Hi Everyone, Someone sent me an excel sheet and they selected the whole sheet and put borders on all cells. They also shaded columns all the way down. I have 72 pages but only want one. I need to keep the borders and shading on cells A1-AG40. I tried to delete the rows by selecting for 41 and dragging down but I got to 50,000 rows and there were still more. How can I clear the contents of everything below row 41 and keeping everything above intact? Thanks, Linda |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
gridlines and formatting will not print Excel 2003 | Excel Discussion (Misc queries) | |||
Excel won't print the gridlines | Setting up and Configuration of Excel |