Question about Computers & Internet

1 Answer

Freeze panes excel mac

Every time I try to freeze pane the computer program wont let me. Everything is highlighted but not the freeze pane function

Posted by Anonymous on

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Master:

    An expert who has achieved Level 3.

  • Master
  • 630 Answers

2 Suggested Answers

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

  • 1 Answer

SOURCE: freeze panes doesn't work in mac excel

HOW TO FREEZE THE TOP ROW OF EXCEL FOR MAC:

Wow - using the above ideas I figured out how to freeze the top row!!! Thanks guys!! Here's how:

1.) Use 'Normal' View (i.e. look up at tool bar, hover over 'View' and make sure 'Normal' is checked)
2.) Select cell B2 (only the cell, not the row or the column)
3.) Click 'Window' (from the tool bar at the top of your screen)
4.) Click 'Freeze Panes'

...et voila! :-)

Posted on Oct 29, 2010

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How do I Freeze panes in MacBook Air


In Excel on your MacBook Air? If so, try this video tutorial:

How to Freeze Pane in Excel on mac

May 14, 2014 | Apple Air Computers & Internet

1 Answer

How to freeze 2 or more rows in excel using mac desk top


click on second row
febba622-a6d7-4d94-a649-06e01d10f50d.png
then chose freeze panes from menu
15adc35b-11ee-4a5e-8bab-8bdc8a12cdf5.png

Nov 20, 2013 | Apple Computers & Internet

1 Answer

Cursor is stuck in the middle of the page and will not move to the left side. The back space button or the shift left button do not respond?


You've probably "frozen" your pane. "Freeze Panes" is a feature which allows you to keep one or more left-hand columns or top rows visible while you scroll through your worksheet.

When you ac

You didn't say which version of Excel your're using, but in Excel 2007, you can either freeze the Row 1, Column A, or any number of rows and columns based on which cell is selected (i.e., where your cursor is) when you click on "Freeze Panes."

In Excel 2007*, the way to fix this would be to click on the "View" tab, then the "Freeze Panes" icon, which will give you several choices. Click on "Unfreeze Panes." There you go.

* The steps are similar in other versions.

Aug 27, 2013 | Microsoft Excel for PC

1 Answer

Cell freeze 3 rows together at a time.


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

Aug 14, 2013 | Microsoft Office Computers & Internet

1 Answer

How to freeze columns and rows on excel?


To freeze columns and rows in Excel, here's what you need to do:

- Excel 2003 & older: To do this, open your Excel spreadsheet. Select the cell that is below the left-most column heading that you wish to see. Then under the Window menu, select Freeze Panes.

- Excel 2007 & newer: Click on the View tab, and then on Freeze Panes. In here you have 3 options, first one does exactly the same thing as the one from older versions, second one freezes the top row and the last one freezes the first column.

Dec 02, 2010 | Microsoft Computers & Internet

1 Answer

When I freeze a pane (at E6), the dropdown menus in column B no longer work.


HAHAHA I figured out how to freeze the left column successfully on excel for MACS.... So select the cell that is one column to the right and one cell below the column you want to freeze. So if you want to freeze the A column From row 1 - 35, select B36. Get it?? Took me forever, but i figured it out!!! I still have no clue how you could freeze a header row as well, but this is enough for me

Feb 10, 2010 | Apple Mac Pro Desktop

1 Answer

Not able to scroll on my excel sheet


It's only in Excel you can't scroll? Can you scroll from side to side? If you have Excel 2003, try to press the "window" tab on the top and if the freeze pane is checked, uncheck it. Or if it says unfreeze pane, press that one. Hope this helps :)

Jul 20, 2009 | IBM ThinkPad T42 Notebook

3 Answers

Freeze panes doesn't work in mac excel


HOW TO FREEZE THE TOP ROW OF EXCEL FOR MAC:

Wow - using the above ideas I figured out how to freeze the top row!!! Thanks guys!! Here's how:

1.) Use 'Normal' View (i.e. look up at tool bar, hover over 'View' and make sure 'Normal' is checked)
2.) Select cell B2 (only the cell, not the row or the column)
3.) Click 'Window' (from the tool bar at the top of your screen)
4.) Click 'Freeze Panes'

...et voila! :-)

Apr 09, 2009 | Apple Mac Pro Desktop

1 Answer

Mouse scrolling probalem


I believe you and I had the same problem. I just figured it out, actually by accident!

In MS-Excel, on the top tool bar (File, Edit, View etc etc.) there should be a tab next to the Help tab, called Window.
Click Window, then look through the drop down until you see UnFreeze Panes (Note that the problem will be fixed if you click UnFreeze Panes, if indeed our problem was the same.)
If you do not see that option "UnFreeze Panes" and instead see Freeze Panes... then I haven't the foggiest how to help. -___-;; 

Good Luck!

Feb 25, 2009 | IBM Lenovo Mouse 76H6618

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

84 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...