Formatting Cells in MS-EXCEL
Shortcut keys are easy to remember to operate and easy to remember. Because of simple keys its easy to handle formatting cells. Shortcuts Ctrl+N: Create a new workbookCtrl+O: Open an existing workbookCtrl+S: Save a workbookF12: Open the Save As dialog…
Most Useful Microsoft Excel Tips
Making sense of our data-rich, noisy world is hard but vital. Used well, Conditional Formatting brings out the patterns of the universe, as captured by your spreadsheet. That’s why Excel experts and Excel users alike vote this the #1 most important…
How to Format Cells in Excel
How to Format Cells in Excel When we format cells in Excel, we change the appearance of a number without changing the number itself. We can apply a number format (0.8, $0.80, 80%, etc) or other formatting (alignment, font, border, etc). To change the…
Few basic tips to work on Excel
Few basic tips to work on Excel 1. Use MS Excel Format Painter To start you off, get yourself familiar with formatting your spreadsheet cells. A visually organized spreadsheet is highly appreciated by others as it can help them follow your data and…
List of Shortcut Keys in Microsoft Excel
Tab Moves one cell to the right in Microsoft excel worksheet. SHIFT+TAB Moves to the previous cell in a worksheet. CTRL+TAB Switches to the next tab in dialog box. CTRL+SHIFT+TAB Switches to the previous tab in a dialog box. CTRL+1 Displays Format Cells…