ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I cannot delete a blank column from an Excel spreadsheet. (https://www.excelbanter.com/excel-discussion-misc-queries/114017-i-cannot-delete-blank-column-excel-spreadsheet.html)

Chris L 99

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


FloMM2

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


hot dogs

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


Chris L 99

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