Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I use a spreadsheet for taking orders on the phone. The spreadsheet has all
of the items we carry listed on it. At the end of the sale I have to delete the columns that have no value in them so I can print the worksheet at a size that can be read. Is there a way to automatically delete those cells without having to select and delete them individually? |
#2
![]() |
|||
|
|||
![]()
Use DataAUtofilter to show the blanks, then delete all visible rows.
-- HTH Bob Phillips "ScaffoldingDepot" wrote in message ... I use a spreadsheet for taking orders on the phone. The spreadsheet has all of the items we carry listed on it. At the end of the sale I have to delete the columns that have no value in them so I can print the worksheet at a size that can be read. Is there a way to automatically delete those cells without having to select and delete them individually? |
#3
![]() |
|||
|
|||
![]()
If they are empty you can select the data, press F5, click special, select
blanks and press Ctrl and - (minus/dash), then depending on if you need the whole row deleted select that otherwise select shift up Regards, Peo Sjoblom "ScaffoldingDepot" wrote: I use a spreadsheet for taking orders on the phone. The spreadsheet has all of the items we carry listed on it. At the end of the sale I have to delete the columns that have no value in them so I can print the worksheet at a size that can be read. Is there a way to automatically delete those cells without having to select and delete them individually? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
Find duplicate rows then deleting them | Excel Worksheet Functions | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
How do i keep the colors applied to the specific rows when sor | Excel Discussion (Misc queries) | |||
Deleting rows containing common data | Excel Discussion (Misc queries) |