These ASCII Codes are interpreted by the application program like Excel, Word, Paint, etc. Function keys provide the same output in all versions of Excel making it easier to recall.īefore we head onto our topic, let us first know about the history of function keys and how do they work.įunction Keys generate fixed, single byte code that is outside the range of normally used ASCII Codes. In this article, we are going to discuss the use of excel function keys (F1 to F12). WPS Academy list some of the most important Microsoft Excel shortcuts for Windows, PC, Mac, Linux, Android, and iOS devices to make your work easier.Function Keys in Excel are a handy and faster way of doing certain tasks by using the keyboard instead of a mouse. There's no denying the fact that shortcuts make our lives easier and if you're an Excel user, you can refer to WPS Spreadsheet guide to learn some of the major shortcuts. The most useful Microsoft Excel Keyboard Shortcuts can be free to learn in WPS Academy. Take a shortcut with 11 Excel workbook and ribbon tab shortcut keys To learn more shortcut key s in excel, please click the following links: If you're used to using the mouse to process data and worry about the low work efficiency, it's well worth the effort to master these crucial shortcuts listed as followed.Ĭtrl+C&Ctrl+V: Copy and paste the cell value.Ĭtrl+Shift+Arrow keys: Select all the cells from a certain direction.Ĭtrl+L or Ctrl+T: Create a table automatically.Ĭtrl+ : Insert the current date quickly. Frequently used Excel shortcut key s for cell editing:Ĭells are the basic form of our sheets.Ĭtrl + Shift + !: A pply the Number format Ĭtrl + Shift + #: A pply the Date format. Ĭtrl + Shift + $ : A pply the C urrency format. Frequently used Excel shortcut key s for cell formatting:Ĭhoosing proper cell formats can make the data easier to read and analyze.Ĭell Formatting: Ctrl+1: Open the Format Cells dialog box and thus custom the cells on your own.Ĭtrl+B or Ctrl+2: To make the cell value bold.Ĭtrl+L or Ctrl+3: To italicize the cell value.Ĭtrl + Shift + % : A pply the P ercent format.Learning how to navigate in cells can make the user experience more smoothly.Ī rrow key s ( Up, Down, Left and Right ) allow you to navigate among cells.Īrrow keys + Ctrl: Go to the edge of the current data area. Frequently used Excel shortcut key s to move in cells:.Today, we'll learn how to use shortcuts for cells.
Given a large number of shortcuts to investigate, we must first classify them. Instead of using the mouse to access the toolbar, smart individuals will find clever methods to do various tasks. WPS Spreadsheet has a great many shortcut key s to assist you in working faster and more efficiently.
0 kommentar(er)
