I want to freeze 3 rows together at a time so that if any of the values in the group of 3 are filtered then all three values are also displayed. How is this done in excel 2007?
Freeze a Row in Microsoft Excel
Microsoft Excel 2010 can freeze, or lock, a top row as you
scroll down the worksheet.
For example, you may need to keep the top row of column
titles visible at all times.
The "View" tab on the command ribbon contains the
"Freeze Panes" button in the "Window" group.
A single row or a range of rows can lock through the
"Freeze Top Row" or "Freeze Panes" options.
Open the Excel worksheet.
Click the top row heading.
The row heading displays a number just left of the first
column of cells. The selected row appears shaded.
Click the "View" tab on the command ribbon.
Click the "Freeze Panes" button in the
"Window" group.
A list of options appears.
Click the "Freeze Top Row" option.
A black horizontal line appears on the worksheet.
This line indicates the locked row that stays on the screen
as you scroll down the worksheet.
http://office.microsoft.com/en-us/excel-help/freeze-or-lock-rows-and-columns-HP010342542.aspx?CTT=1
Freeze or lock rows and columns
also
Use Freeze Panes in Excel
Scrolling down to look at a number and then scrolling up to
make sure the number you looked at is under the header you expected is not an
efficient way to view a spreadsheet.
The Freeze Panes feature of Excel allows you to freeze the
labels of your data in place while you review the data.
Follow the instructions in Section 1 to freeze the top row
or the left column.
Freeze multiple rows, multiple columns, or rows and columns,
by following the instructions in Section 2.Freeze the Top Row or Left Column
1
Open the Excel spreadsheet.
2
Navigate to the "View" tab on the top menu.
3
Click on "View," then click on "Freeze
Panes." A drop-down menu opens.
4
Select the "Freeze Top Row" option to freeze the
top row.
5
Select the "Freeze Left Column" or "Freeze
First Column" option to freeze the left column.
6
Freeze the top row by using the keyboard and sequentially
pressing the keys "ALT, W, F, R." Ignore Steps 3 through 7 if using
this choice.
7
Freeze the left column using the keyboard by sequentially
pressing the keys "ALT, W, F, C." Ignore Steps 3 through 7 if using
this choice.
8
Unfreeze panes by repeating Steps 3 through 5 and selecting
"Unfreeze Panes" or sequentially press the keys "ALT, W, F,
F."
Freeze Rows and Columns, Multiple Rows, Multiple Columns,
or Multiple Rows and Columns
9
Open the Excel spreadsheet.
10
Freeze column(s) and row(s) at the same time by selecting
the cell to the right of and below the location you want to freeze.
11
Freeze multiple rows only by selecting the cell in the left
(first) column below the rows you want to freeze.
12
Freeze multiple columns only by selecting the cell in the
top row to the right of the columns you want to freeze.
13
Navigate to the "View" tab on the top menu.
14
Click on "View," then click on "Freeze
Panes." A drop-down menu opens.
15
Select the "Freeze Panes" option. You have now
frozen the columns or rows, or columns and rows you designated.
16
Freeze panes using the keyboard by sequentially pressing the
keys, "ALT, W, F, F." Ignore Steps 5 through 8 if using this choice.
17
Unfreeze panes by repeating Steps 5 through 7 and selecting
"Unfreeze Panes" or sequentially press the keys, "ALT, W, F,
F."
http://office.microsoft.com/en-us/excel-help/freeze-or-lock-rows-and-columns-HP001217048.aspx
Freeze or lock rows and columns
http://office.microsoft.com/en-us/excel-help/demo-hide-or-unhide-rows-and-columns-HA010241040.aspx
Hide or show rows and columns
SOURCE: EXCEl 2007
Use the "IF" function. Help should give you all the examples you will need.
If this helps you, please rate me. Thanks, Patty
SOURCE: Excel Formula
Place the following in the cell you want to display the result:
=MAX(l15:l37)
Logically this reads the cells you have circled, reads the highest #, and places it in the cell you put the formula in. ( you have indicated cell m16 in the screencap)
Hope this is what you are looking for.
SOURCE: Excel Formula
Highlight the range of cells that contain the numbers you want included. Click on the cell where you want the highest value displayed. Click on the paste function button select MAX and click <OK>
341 views
Usually answered in minutes!
×