0
What else can I help you with?
In Microsoft Excel if you want to hide a column of one part of the page how do you keep the other part visible?
Select only the column you want to hide. All of the other columns will be visible. Your question is not clear, so if you mean how do you hide a part of a column and not the entire column, then just change the font color to white in the range you want to hide.
What is the purpose behind freezing row and column headings?
It allows people to scroll down or across and maintain the headings on the screen. If you have a lot of rows or columns with headings on them, it can be easy to lose track of which row or column is meant to hold the data you want to enter. Having the headings permanently in view gets rid of that problem.
What happens when you hide a column in Microsoft Excel?
The column disappears from view so you cannot see it. You will notice its heading is missing, so if column H was hidden you would see column G and then column I. The values in column H can still be used in the worksheet by referencing them in the normal way. Hiding columns can be useful for hiding data that you do not want to be seen or that you do not want users to change or that does not need to be seen. It can be used to put in supporting data to a worksheet rather than having it cluttering up the screen by being visible.
Can you freeze the top row and the left column at the same time?
Yes, you can freeze both the top row and the left column simultaneously in spreadsheet applications like Microsoft Excel or Google Sheets. To do this, you typically need to select the cell immediately below the row you want to freeze and to the right of the column you want to freeze. Then, you can use the "Freeze Panes" option from the view menu to apply the freeze. This allows you to keep both the top row and the left column visible while you scroll through the rest of the data.
Can you use column and row titles within formulas when you want to refer to the related data by name?
If you have given the data a name, there is no point in referencing them by the row and column. You could but, why would you want to?
Do you pick a certain column when you use the MIN?
You can choose whatever is the appropriate range of data. That could be in a column, or part of a column or in a row. It depends on where you have the data stored that you want to use the MIN function on.
When you want to reference an entire column of data in a table what should you do?
qualifier
What is the proper way to set up a data table?
For Excel, it depends on the kind of table you are setting up. You can have a one-input or a two-input table. For a one input you put a set of figures either in a column or a row. You then need a formula for the table to work off. That is put at the top of the empty column that you want data to go into, or the start of the empty row that you want to put data into. Select your formula, the row/column of figures and the blank row/column where data is going to go. You then start the Data Table option. You will be asked for a row input and a column input. If you have your figures in a column, then you put a cell reference into the column input that is in the formula. If they are in a row, then you use the row input. The data fills in then. For a two-input, you will have data in a row and data in a column and a formula in the cell which is above the column and at the start of the row, or the top left cell in the table. You select the row and column with the existing data and the area you want the data to go into. Pick your row and colmn inputs based on the cells in the main formula. Your table will then fill in.
An alternative to increasing the column widths or row heights is to?
In order to make data in cells to be seen, if you don't want to change row or column sizes you can change the font size of the data.
How do you break particular data of vertical to horizontal in Excel?
You can transpose data. Select the cells in a column. Do a copy. Move to where you want the data to go to. Then do a Paste Special and pick Transpose. The orientation of the data will be changed so that it is now in a row rather than a column.
When is it not necessary to specify a data type for a column when creating a table?
You do not need to specify a data type when you want to accept the default format.
In excel 2007 if a have a column of names most of which are repeated can you build a formula that will look at that column and pick out each name once and place it in a different column?
In Excel 2007, the quickest and easiest way to accomplish this is to copy your data to a new column and apply the Remove Duplicates command.Given a column of data in column A.Click on A, the column heading.Press Ctrl-C to copy the column.Click on B, the column heading for the next column.Press Ctrl-V to copy the data from column A to column B.Click on B, the column heading.Click on the Data tab on the menu ribbon bar.In the Data Tools section, click on the Remove Duplicates button (continue with current selection).Observe that column B contains only one copy of each item from column A.If you want the list in alpabetic or numeric order, just sort column B.
