Excel

Highlighted
Tory Guidry
New Contributor

Excel

I have a spreadsheet that everytime I sort the data it does the following:

 

adds a blank line

1)erases the border around the last entry

2)changes the sort data from auto to one of the colors I have already specified to sort by ( I have to cut the header row & reinsert to get the information to sort correctly).

3)when I print the document it prints in small font (i am selecting several rows & telling the printer to only print the selection)

 

Any help would be appreciated.

 

2 Replies

Re: Excel

Hello,

 

can you post a file with some sample data that shows the behaviour? It's quite hard to recommend anything without being able to at least inspect the problem. 

Re: Excel

I have attached images of the issues I am having.  The sort issue is not acting up at the moment but basically it gets hung up & wants to get rid of the automatic & sort w/an existing color.  The lines disappear when I sort on the bottom & sometimes adds an extra line above.  Also the print is fine on the screen but when I print it is printing small.

Related Conversations
Copy/paste no longer working in Excel
Jon Firooz in Excel on
57 Replies
Security Warning: Automatic update of links has been disabled.
Mark Adams in Excel on
6 Replies
EXCEL DO NOT SHOW GRAPH MAP CHART
Mark 777 in Excel on
47 Replies
Running Comparison
Robert V Giancarlo in Excel on
11 Replies
Excel Compare Data
Arnold Lopez in Excel on
12 Replies
Force user to SAVEAS
Man Fai Chan in Excel on
12 Replies