SORTING

K

KATHRAY

I have a Large Spreadsheet and i use Auto Filter to find the Info i require.
No Problems.
In the Original Spreadsheet some CELLS i have BOARDERS arround.
Auto Filter places them correctly.
The trouble im having is wheni SORT the NEW FILTERED PAGE the BOARDERS stay
in the same CELLS.
Is there anyway i can get the BOARDERS/BOX'S to move with the original DATA.
THANKING YOU
 
J

Jim Cone

Auto Filter hides entire rows, it does not move any data.
Sorting in Excel moves data, however borders (and conditionally formatted colors)
do not move with the data.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins - check out "Special Sort")



"KATHRAY"
wrote in message ...
I have a Large Spreadsheet and i use Auto Filter to find the Info i require.
No Problems.
In the Original Spreadsheet some CELLS i have BOARDERS arround.
Auto Filter places them correctly.
The trouble im having is wheni SORT the NEW FILTERED PAGE the BOARDERS stay
in the same CELLS.
Is there anyway i can get the BOARDERS/BOX'S to move with the original DATA.
THANKING YOU
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hold conditional formatting when sorting filtered data 1
Auto Filter Sorting Issue 1
Background stays when sorting 2
row height does not move with row when sorting 1
pasting with filter results into sequentual cells not same row? 1
Saving Auto-Filtered Data (or deleting the rest) 3
sorting spreadsheet with conditional formatting 1
Help Sorting Outline Numbers 5

Top