SORTING

  • Thread starter Thread starter KATHRAY
  • Start date Start date
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
 
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

Fill without formatting 1
How do I map the route of curser to specific input cells excel 1
How do I unselect a cell in a macro 2
Auto Filter Sorting Issue 1
Hold conditional formatting when sorting filtered data 1
Pivot Table Formatting 1
Paste from Excel to a text box as straight text 2
Rows with a height of zero 2

Back
Top