Excel is a useful short cut keys:
comets Press Control + Shift + O to select only the cells (Ctrl + Shft + O) press. No cell comets not No Cells found that the message is available.
selected formula any cells involved in everything there is to know CTRL + [Press.
Ctrl +] keys, press the cell cursor is on the cell involved formulas displayed.
Shift + Arrow key (Shft + Arrow key ) Pressing the election of a cell is extended.
Ctrl + Shift + Arrow key (Ctrl + Shft + Arrow key ), press the same bed or thrust line of data in the last cell until the selection is extended.
Shift + Home keys (Shft + Home ) pushing bed sequence of the first cell the selection is extended.
Ctrl + Shift + Home (Ctrl + Shft + Home) keys push the selection work sheet, the first cell and extending.
Ctrl + Shift + End (Ctrl + Shft + End) keys pushing the selection orksit last used cell until it is stretched.
enter key (Enter) pushing completed the cell cursor to the cell below. day, month and year: Customize the Excel package to our day, month and year of the number've displayed. Let's see how to set it. according to the date on which cells you want to select them. Then go to the Format menu and select Cells. Right-click or Control + 1, or select Format Cells from the menu. Get the Number Format Cells dialog window, then click Table. On the left side of the window, select Custom and under. Type in the number of Options to see . Set the date and the year in which you wish to see in the genre. Here is the list of them. On Categories: D a day to give the number (1, 2, 3, 4 ... 30, 31) dd two digits give the number of days (01,02,03) ddd and will be summarized in a single day ( M On, Tue ....) dddd day that will give its full name ((Monday, Tuesday, etc). monthly Notes: m is the number of a given month (1, 2, 3, 4 ... 30, 31) mm is gives the number of the month in two digits (010203) mmm will summarize the month (Jan, Feb, ....) mmmm give it its full name of the month (January, February etc). mmmmm of the month will be the first character (J, F, M, A,) Notes for the year yy two digits of the year number will be (13,14,12) yyyy is the year in which the number of four digits (2012, 2013, 2014)
comets Press Control + Shift + O to select only the cells (Ctrl + Shft + O) press. No cell comets not No Cells found that the message is available.
selected formula any cells involved in everything there is to know CTRL + [Press.
Ctrl +] keys, press the cell cursor is on the cell involved formulas displayed.
Shift + Arrow key (Shft + Arrow key ) Pressing the election of a cell is extended.
Ctrl + Shift + Arrow key (Ctrl + Shft + Arrow key ), press the same bed or thrust line of data in the last cell until the selection is extended.
Shift + Home keys (Shft + Home ) pushing bed sequence of the first cell the selection is extended.
Ctrl + Shift + Home (Ctrl + Shft + Home) keys push the selection work sheet, the first cell and extending.
Ctrl + Shift + End (Ctrl + Shft + End) keys pushing the selection orksit last used cell until it is stretched.
enter key (Enter) pushing completed the cell cursor to the cell below. day, month and year: Customize the Excel package to our day, month and year of the number've displayed. Let's see how to set it. according to the date on which cells you want to select them. Then go to the Format menu and select Cells. Right-click or Control + 1, or select Format Cells from the menu. Get the Number Format Cells dialog window, then click Table. On the left side of the window, select Custom and under. Type in the number of Options to see . Set the date and the year in which you wish to see in the genre. Here is the list of them. On Categories: D a day to give the number (1, 2, 3, 4 ... 30, 31) dd two digits give the number of days (01,02,03) ddd and will be summarized in a single day ( M On, Tue ....) dddd day that will give its full name ((Monday, Tuesday, etc). monthly Notes: m is the number of a given month (1, 2, 3, 4 ... 30, 31) mm is gives the number of the month in two digits (010203) mmm will summarize the month (Jan, Feb, ....) mmmm give it its full name of the month (January, February etc). mmmmm of the month will be the first character (J, F, M, A,) Notes for the year yy two digits of the year number will be (13,14,12) yyyy is the year in which the number of four digits (2012, 2013, 2014)
No comments:
Post a Comment