![]() |
I cannot delete a blank column from an Excel spreadsheet.
I have a data spreadhseet fitted to one landscape page. However when I print,
there is always a second page with one single blank column. No matter how I try to delete that single column, I cannot. Suggestions please? I am using Microsoft Office 2003 on a Toshiba notebook Tecra S-1 |
I cannot delete a blank column from an Excel spreadsheet.
Chris L 99,
Try this: Open the worksheet. Select View select Page Break Preview You will have to select OK. Then Move the blue line, it is probably a dashed line, to the end of your column. Save, select View, select Normal. Try a print preview first, and make sure it is only one page or what you want. "Chris L 99" wrote: I have a data spreadhseet fitted to one landscape page. However when I print, there is always a second page with one single blank column. No matter how I try to delete that single column, I cannot. Suggestions please? I am using Microsoft Office 2003 on a Toshiba notebook Tecra S-1 |
I cannot delete a blank column from an Excel spreadsheet.
Select the entire area you want to print, go to file/print area/set print
area. Then go to print, select print preview/setup, and fit to 1 page tall by one page high. "Chris L 99" wrote: I have a data spreadhseet fitted to one landscape page. However when I print, there is always a second page with one single blank column. No matter how I try to delete that single column, I cannot. Suggestions please? I am using Microsoft Office 2003 on a Toshiba notebook Tecra S-1 |
I cannot delete a blank column from an Excel spreadsheet.
Dear FloMM2,
Thanks, that worked first time! You are an Excel Guru! Best regards Chris L 99 "FloMM2" wrote: Chris L 99, Try this: Open the worksheet. Select View select Page Break Preview You will have to select OK. Then Move the blue line, it is probably a dashed line, to the end of your column. Save, select View, select Normal. Try a print preview first, and make sure it is only one page or what you want. "Chris L 99" wrote: I have a data spreadhseet fitted to one landscape page. However when I print, there is always a second page with one single blank column. No matter how I try to delete that single column, I cannot. Suggestions please? I am using Microsoft Office 2003 on a Toshiba notebook Tecra S-1 |
All times are GMT +1. The time now is 06:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com