0
The short key to hide a row in MS Excel is Ctrl key and the number nine. The short key to hide a column is Ctrl key and the number zero. You first need to click on a cell in the column or row that you want to hide.
Wiki User
∙ 8y ago
Add your answer:
Earn +20 pts
To hide a column in Excel begin by selecting the column and then what?
You can press Ctrl and the zero key. Ctrl-Shift-0 will unhide it. There is also the column options which include hiding and showing columns.
Can you hide columns and rows in Excel?
Yes you can. Ctrl - 9 hides a row. Ctrl - 0 hides a column. Add the Shift key to those combinations and they can be unhidden.
How do you do column width command in Excel?
When you say column with command, you mean automatically adding a new column or autoadjusting a column?To add a column using a shortcut, you need to highlight a column/s first (short cut is Shift key + Space bar) then press your Ctrl and + Keys simultaneously.If you want to auto-adjust a column's width using a shortcut, you can use Alt + H O + I (texted with Excel 2007 version).
How do you select nonadjacent columns or rows in excel?
After selecting the first row or column, press and hold the ctrl key and click on the header of the next row or column you want to select.
How do you form a primary key column in Microsoft Excel?
Just type your data into the column. Excel is not really a database program, but you can create a flat database file and some elementary relations between worksheets. A better tool for a database would be MS Access.
How do you select column Q to column T in with any shortcut key Excel?
Put the cursor on any cell in column q. Press and hold the Shift key and press the right arrow key and select over as far as column t so that one cell in each of column q, r, s and t are selected. Then press and hold the Ctrl key and then press the space bar. All of those columns will now be selected.
How can you access the Show Formulas button in Excel?
It is on the Formulas tab, in the Auditing section. To hide or show formulas you can also just press Ctrl and the `key, which is the key beside the 1 key on your keyboard.
Which short cut key is used to select the top leftmost cell of the Excel sheet?
Ctrl-Home will bring you to cell A1 in a worksheet in Excel.
Alt- equals mean on a Excel sheet?
Alt Equals is one of the many shortcut key combinations in Excel. It is used to trigger the SUM function. So if you have a column of numbers, you could put the cursor in a blank cell at the bottom. If you then pressed Alt and the Equals key, it would enter a SUM function that selects the cells in the column with the numbers. Pressing Enter would put the formula into the cell.Alt Equals is one of the many shortcut key combinations in Excel. It is used to trigger the SUM function. So if you have a column of numbers, you could put the cursor in a blank cell at the bottom. If you then pressed Alt and the Equals key, it would enter a SUM function that selects the cells in the column with the numbers. Pressing Enter would put the formula into the cell.Alt Equals is one of the many shortcut key combinations in Excel. It is used to trigger the SUM function. So if you have a column of numbers, you could put the cursor in a blank cell at the bottom. If you then pressed Alt and the Equals key, it would enter a SUM function that selects the cells in the column with the numbers. Pressing Enter would put the formula into the cell.Alt Equals is one of the many shortcut key combinations in Excel. It is used to trigger the SUM function. So if you have a column of numbers, you could put the cursor in a blank cell at the bottom. If you then pressed Alt and the Equals key, it would enter a SUM function that selects the cells in the column with the numbers. Pressing Enter would put the formula into the cell.Alt Equals is one of the many shortcut key combinations in Excel. It is used to trigger the SUM function. So if you have a column of numbers, you could put the cursor in a blank cell at the bottom. If you then pressed Alt and the Equals key, it would enter a SUM function that selects the cells in the column with the numbers. Pressing Enter would put the formula into the cell.Alt Equals is one of the many shortcut key combinations in Excel. It is used to trigger the SUM function. So if you have a column of numbers, you could put the cursor in a blank cell at the bottom. If you then pressed Alt and the Equals key, it would enter a SUM function that selects the cells in the column with the numbers. Pressing Enter would put the formula into the cell.Alt Equals is one of the many shortcut key combinations in Excel. It is used to trigger the SUM function. So if you have a column of numbers, you could put the cursor in a blank cell at the bottom. If you then pressed Alt and the Equals key, it would enter a SUM function that selects the cells in the column with the numbers. Pressing Enter would put the formula into the cell.Alt Equals is one of the many shortcut key combinations in Excel. It is used to trigger the SUM function. So if you have a column of numbers, you could put the cursor in a blank cell at the bottom. If you then pressed Alt and the Equals key, it would enter a SUM function that selects the cells in the column with the numbers. Pressing Enter would put the formula into the cell.Alt Equals is one of the many shortcut key combinations in Excel. It is used to trigger the SUM function. So if you have a column of numbers, you could put the cursor in a blank cell at the bottom. If you then pressed Alt and the Equals key, it would enter a SUM function that selects the cells in the column with the numbers. Pressing Enter would put the formula into the cell.Alt Equals is one of the many shortcut key combinations in Excel. It is used to trigger the SUM function. So if you have a column of numbers, you could put the cursor in a blank cell at the bottom. If you then pressed Alt and the Equals key, it would enter a SUM function that selects the cells in the column with the numbers. Pressing Enter would put the formula into the cell.Alt Equals is one of the many shortcut key combinations in Excel. It is used to trigger the SUM function. So if you have a column of numbers, you could put the cursor in a blank cell at the bottom. If you then pressed Alt and the Equals key, it would enter a SUM function that selects the cells in the column with the numbers. Pressing Enter would put the formula into the cell.
How can I return a column header in Microsoft Excel from a range by finding the row searching down on the leftmost column and the column searching right on that column?
Not sure what you are asking, but you can get to a particular column by using the GOTO function (press F5 key). If this does not answer your question, please ask another question that is more specific to your needs.
What shortcut is available in Microsoft Excel to add numbers in a column?
You can add an entire column by using =sum(a:a) for example, which would sum all amounts in column A. Also, holding down the Alt key while hitting the equal sign right below a column of numbers will sum that column
What is the row height of Excel 2007?
By selecting an empty row and pressing Ctrl + 'Down arrow key', the selected cell will be the next item down the column. The row height in Excel 2010 is 1048576 cells.
