Here it goes two questions about working in excel. One i believe should be easy to explain but the other a bit harder. If you guys dont have the time dont worry about explaining number two, i will figure it out someday!!! 1. I want to make two colums one of numbers 1 - 20 and the next column of a particular item "X" then i want to make the next 40 or 50 columns different variables. What im trying to ask is how do i get the first two columns to not dissapear when i scroll left and right. In other words i want to be able to scroll through all the variables but still see 1. item "x" then the rest . 2. My next question would be if i have around 60 colummns and 600 rows how would i "filter" and is it time consuming to do??? Thanks for the help..
1) Click to highlight column C, then click Window>Freeze panes. This will hold columns A and B in place. 2) Filtering or Sorting commands are found under Tools. There are a lot of ways to filter and sort, depending on what you want to do. Hard to explain it without knowing what your data is and how you want to filter or sort it.
1. Behad is exactly correct. 2. If the filtering you want to do is basic, highlight all the data and choose Data -> Filter -> Autofilter. The top row will become a column heading with a drop-down list, and you'll have all kinds of ways to filter through that.
First thank alot guys, second i knew my first question was easy but now my second question is easier to do...... now im not that impressed with some of the excel spreadsheets i receive!! Its pretty simple i thought it was harder to filter in excel.. again thanks.
