ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I delete extra (blank) pages in excel??? (https://www.excelbanter.com/excel-discussion-misc-queries/130946-how-do-i-delete-extra-blank-pages-excel.html)

Arbee5

How do I delete extra (blank) pages in excel???
 


ExcelBanter AI

Answer: How do I delete extra (blank) pages in excel???
 
Deleting extra blank pages in Excel is a simple process. Here are the steps you can follow:
  1. Open the Excel workbook that contains the extra blank pages.
  2. Click on the sheet tab of the blank page you want to delete.
  3. Right-click on the sheet tab and select "Delete" from the drop-down menu.
  4. A dialog box will appear asking you to confirm the deletion. Click on "Delete" to confirm.
  5. The blank page will be deleted, and the remaining pages will shift to fill the gap.

If you have multiple blank pages to delete, you can repeat this process for each page. Alternatively, you can select multiple sheet tabs by holding down the "Ctrl" key and clicking on each tab. Then, right-click on one of the selected tabs and choose "Delete" to delete all selected tabs at once.

That's it! Your extra blank pages should now be deleted, and your Excel workbook should be more streamlined and easier to navigate.

Max

How do I delete extra (blank) pages in excel???
 
If you mean sheets ..
just right-click on the sheet tab Delete
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Arbee5" wrote in message
...


How do I delete extra (blank) pages in excel???



Arbee5

How do I delete extra (blank) pages in excel???
 
Thanks Max, but I mean pages.....My excel document is three pages...When I
print, it prints three pages and then a blank page...the acual document is
four pages....I can't get rid of the fourth page that isn't needed.....clear
as mud??

"Max" wrote:

If you mean sheets ..
just right-click on the sheet tab Delete
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Arbee5" wrote in message
...


How do I delete extra (blank) pages in excel???




Gord Dibben

How do I delete extra (blank) pages in excel???
 
FilePrint AreaClear.

Then select the area you want to print and FilePrint AreaSet Print Area


Gord Dibben MS Excel MVP

On Thu, 15 Feb 2007 17:36:10 -0800, Arbee5
wrote:

Thanks Max, but I mean pages.....My excel document is three pages...When I
print, it prints three pages and then a blank page...the acual document is
four pages....I can't get rid of the fourth page that isn't needed.....clear
as mud??

"Max" wrote:

If you mean sheets ..
just right-click on the sheet tab Delete
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Arbee5" wrote in message
...


How do I delete extra (blank) pages in excel???





leosnr

How do I delete extra (blank) pages in excel???
 
I found that there was some data in a field in the next page. Go to this by
using ControlEnd together and delete it. Whammo it prints the pages you want.

"Gord Dibben" wrote:

FilePrint AreaClear.

Then select the area you want to print and FilePrint AreaSet Print Area


Gord Dibben MS Excel MVP

On Thu, 15 Feb 2007 17:36:10 -0800, Arbee5
wrote:

Thanks Max, but I mean pages.....My excel document is three pages...When I
print, it prints three pages and then a blank page...the acual document is
four pages....I can't get rid of the fourth page that isn't needed.....clear
as mud??

"Max" wrote:

If you mean sheets ..
just right-click on the sheet tab Delete
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Arbee5" wrote in message
...


How do I delete extra (blank) pages in excel???







All times are GMT +1. The time now is 09:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com