1
   

excel and column headers

 
 
profhig
 
Reply Wed 3 Mar, 2004 11:27 am
After a crash on my m/c and losing a lot of data, I decided to re-design my bank and credit card worksheets, making them easier to read and generally tidier. My problem is that I want to leave row 1 and column A blank. I want to put my column headers in row 2, leave row three blank, freeze the frames and enter data starting at row 5. I can do this, but I often have to sort the data by date, and because my headers are not in the top row, they are being sorted with the data and the spaces are also getting sorted and put at the end. Is there a way to get Excel(2002) to ignore the blank rows I want it to, and read the row I am using as the header as the header?
As you can see, this is a 10 drink headache for me!!!!
thanx in advance.
by the way, I am not conversant with vba and macro's, so if this is the only solution I would need an A to Z guide.
DrunkDrunkDrunkDrunkDrunkDrunkDrunkDrunkDrunkDrunk
  • Topic Stats
  • Top Replies
  • Link to this Topic
Type: Discussion • Score: 1 • Views: 832 • Replies: 2
No top replies

 
Peace and Love
 
  1  
Reply Wed 3 Mar, 2004 11:51 am
you can select an area by clicking on a row number in the far left-hand side of your screen..... holding down the left-click on your mouse, drag the mouse down to highlight the area to be sorted....

after selecting your area, click on "data", then click on "sort"..... change the column letter to the one you want.... click OK.... TaDa... easy as pie!!

Let us know if that works for you......


PaL
:-)
0 Replies
 
profhig
 
  1  
Reply Thu 15 Jul, 2004 01:03 pm
Excel and column headers
thanks for the reply, peace and love. i have things pretty much as i want now. due to a serious sequence of problems with my pc i have been busy getting it ship-shape again, so haven't visited for a while. just thought i'd catch up on posts.
DrunkDrunk
0 Replies
 
 

Related Topics

Clone of Micosoft Office - Question by Advocate
Do You Turn Off Your Computer at Night? - Discussion by Phoenix32890
The "Death" of the Computer Mouse - Discussion by Phoenix32890
Windows 10... - Discussion by Region Philbis
Surface Pro 3: What do you think? - Question by neologist
Windows 8 tips thread - Discussion by Wilso
GOOGLE CHROME - Question by Setanta
.Net and Firefox... - Discussion by gungasnake
Hacking a computer and remote access - Discussion by trying2learn
 
  1. Forums
  2. » excel and column headers
Copyright © 2025 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.13 seconds on 12/23/2025 at 05:34:43