Tory Guidry
New Contributor


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



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
44 Replies
Mark 777 in Excel on
47 Replies
Split data from one column into two columns
Jonni Anderson in Excel on
6 Replies
align decimals in a column
Jonni Anderson in Excel on
15 Replies
Excel Compare Data
Arnold Lopez in Excel on
12 Replies
blink a cell
Lorenzo Kim in Excel on
12 Replies