0
How do you modify a worksheet so the first rows is always visible?
Wiki User
∙ 10y ago
There are two methods to do this: either split the worksheet pane, or freeze the row. To split: if you look on the right side of the pane, next to the column headers (A, B, C, . . .), just above the top scroll arrow, you will see a horizontal bar. You can drag and drop this downwards to open a split screen view. You can also freeze the rows by using the menu option "Freeze Panes". The exact location of "Freeze" on the menu changes in different versions of Excel from the old menus to the new "ribbon" system of versions 2007 and 2010. But look for it - you'll find it!
The appearance and behavior of each method is slightly different, so you may want to experiment with both.
Wiki User
∙ 10y ago
Add your answer:
Earn +20 pts
Definition for the word active worksheet?
An active worksheet is a spreadsheet that is visible in a workbook. When you open a new workbook, the first sheet you see is the active worksheet.
How can you set default worksheet is workbook?
Sheet1 is always the first worksheet open. There are 3 worksheets by default. You can change that in the options.
When I hide rows to capture a portion of data and copy to another worksheet how do I eliminate the hidden rows in the new worksheet so that I only have a summary of the data required?
Select all the rows you want first, as you would have been doing. Then press F5, which activates the GoTo command. In the dialog box that opens, click on Special. In the section that opens, click the Visible Cells Only option and click OK. Now only the cells that are visible will be selected. Then do your copy as normal, and when you paste into the new worksheet, only the visible data will be pasted, and you will have no hidden data.
What is the first step in planning an effective worksheet?
state the purpose of the worksheet
How do you add a separate worksheet to an existing worksheet?
Rename the tabs for each worksheet to identify the data they contain, Insert a new worksheet after the first worksheet, change the color of the tabs related to each project
Who finished their worksheet first?
Dan did
Why did they invent techongly?
First you have to know what technology is... Broadly speaking, technology is how people modify the natural world to suit their own purposes Hearing that, it was not "invented" but has always been a part of human nature to invent, create, and modify.
What is the first row of a worksheet that identifies the organization purpose and data of the worksheet are called the worksrksheet?
My best guess for a poorly-worded question is worksheet title.
In which ways can you set the row titles to remain visible as you enter the new figures?
*Split the worksheet into 2 vertical panes, w/ the column containing row titles in the first pane *Hide the columns between the first column and the column for November *Freeze the first column
What is the first step in renaming the worksheet in excel?
Right click on the worksheet's tab, which will give you a shortcut menu with the option to rename it.
What is the answer to safe first from a worksheet called tough turkey teasers?
safe on first
What are the three segments of an insects body?
All insects, though not always easily visible, have three body segments. First there is the head, then the Thorax, which is also known as the waist of the insect. Lastly there is the abdomen or backside of the insect.
