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
 
Ad

Advertisements

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

Top