ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Email excel spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/233735-email-excel-spreadsheet.html)

ELLEN L H

Email excel spreadsheet
 
I have an excel spreadsheet that I e-mailed. ONE cell of the spreadsheet
doesn't print when I go to print the e-mail out.

It's a cell that I have merged over 3 columns.
It's a date.

The strange thing is it shows up in my copy of the e-mail but when it prints
the data space is BLANK.

I have another date in the cell above formatted in exactly the same way.
This date shows up and prints out just fine.

JLatham

Email excel spreadsheet
 
Try unmerging the cells and then select all 3 cells and use Format - Cells
and go to the [Alignment] tab and at the bottom of the Horizontal selections
list choose Center Across Selection. May help (may not).


"ELLEN L H" wrote:

I have an excel spreadsheet that I e-mailed. ONE cell of the spreadsheet
doesn't print when I go to print the e-mail out.

It's a cell that I have merged over 3 columns.
It's a date.

The strange thing is it shows up in my copy of the e-mail but when it prints
the data space is BLANK.

I have another date in the cell above formatted in exactly the same way.
This date shows up and prints out just fine.


ELLEN L H[_2_]

Email excel spreadsheet
 


"JLatham" wrote:

Try unmerging the cells and then select all 3 cells and use Format - Cells
and go to the [Alignment] tab and at the bottom of the Horizontal selections
list choose Center Across Selection. May help (may not).


"ELLEN L H" wrote: You're brilliant.....it worked and then I went back in and did a left justify as I wanted and it stayed. You saved me a lot of hair pulling. Tx.

I have an excel spreadsheet that I e-mailed. ONE cell of the spreadsheet
doesn't print when I go to print the e-mail out.

It's a cell that I have merged over 3 columns.
It's a date.

The strange thing is it shows up in my copy of the e-mail but when it prints
the data space is BLANK.

I have another date in the cell above formatted in exactly the same way.
This date shows up and prints out just fine.



All times are GMT +1. The time now is 12:22 AM.

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