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
EXCEL DO NOT SHOW GRAPH MAP CHART
Mark 777 in Excel on
45 Replies
Excel Compare Data
Arnold Lopez in Excel on
12 Replies
Excel filter issues
P DS in Excel on
13 Replies
Missing Excel 2013 worksheet tabs
Mike Hill in Excel on
7 Replies
Setting Print Areas Not Working in Excel 2016
Scott Cox in Excel on
4 Replies
Graphs in excel
Martin Kotuľák in Excel on
5 Replies