Essential keyboard shortcuts

Keyboard shortcuts are the best way to navigate cells or enter formulas more quickly. We’ve listed our favorites below.

Ctrl +[Down|Up Arrow]: Moves to the top or bottom cell of the current column and combination of Ctrl with Left|Right Arrow key, moves to the cell furthest left or right in the current row
Ctrl + Shift + Down/Up Arrow: Selects all the cells above or below the current cell
Ctrl+ Home: Navigates to cell A1
Ctrl+End: Navigates to the last cell that contains data
Alt+F1: Creates a chart based on selected data set.
Ctrl+Shift+L: Activate auto filter to data table
Alt+Down Arrow: To open the drop down menu of autofilter. To use this shortcut:
Alt+D+S: To sort the data set
Ctrl+O: Open a new workbook
Ctrl+N: Create a new workbook
F4: Select the range and press F4 key, it will change the reference to absolute, mixed and relative.

Note: This isn’t an exhaustive list. Feel free to share your favorite keyboard shortcuts in Excel in the comments section below. Literally, I do 80% of excel tasks using shortcuts.

Comments

Education of India Part 2

History [ edit ] Main article: History of education in South Asia The remnants of the library of Nalanda , built in the 5th century BCE by Gupta kings . It was rebuilt twice after invasion, first after an invasion from the Huns in the 5th century BCE and then after an invasion from the Gaudas in the 7th century CE but abandoned after the third invasion by Turkic invaders in the 12th century. Takshasila (in modern-day Pakistan) was the earliest recorded centre of higher learning in India from possibly 8th century BCE, and it is debatable whether it could be regarded a university or not in modern sense, since teachers living there may not have had official membership of particular colleges, and there did not seem to have existed purpose-built lecture halls and residential quarters in Taxila, in contrast to the later Nalanda university in eastern India. Nalanda was the oldest university-system of education in the world in the modern sense of university. There al

Save a Workbook in another File Format

Save a Workbook in another File Format When you save an Excel 2013 Workbook, by default it saves in the .xlsx format. Excel 2013 supports saving in other formats, but whenever you save a workbook in another file format, some of its formatting, data, and features might not be saved. File Formats (File Types) that are supported in Excel 2013 − Excel File Formats Text File Formats Other File Formats Excel File Formats Format Extension Description Excel Workbook .xlsx The default XML-based file format for Excel 2007-2013. Cannot store Microsoft Visual Basic for Applications (VBA) macro code or Microsoft Office Excel 4.0 macro sheets (.xlm). Strict Open XML Spreadsheet .xlsx An ISO strict version of the Excel Workbook file format (.xlsx). Excel Workbook (code) .xlsm The XML-based and macro-enabled file format for Excel 2007-2013. Stores VBA macro code or Excel 4.0 macro sheets (.xlm) Excel Binary Workbook .xlsb The binary file format (BIFF12) for Excel 2007-2013. Template .xltx The defa

ORGANIZATIONAL STRUCTURE OF A DEPARTMENT IN THE GOVERNMENT OF INDIA

ORGANI

Computer Information Update

Search This Blog