If you are a fan of using the keyboard, you might have noticed one problem in Excel 2003. There were often menu items that did not have a keyboard shortcut.
In Excel 2007, every menu item can be selected from the keyboard. To access the new keyboard shortcuts, press and release the Continue reading ‘Office 2007 Keyboard Shortcuts Tips’ »
Keystroke shortcuts for moving the cell cursor Excel offers a wide variety of keystrokes for moving the cell cursor to a new cell. When you use one of these keystrokes, the program automatically scrolls a new part of the worksheet into view, if this is required to move the cell pointer. Continue reading ‘Keystroke Shortcuts To Move Cells Cursor’ »
To add any Ribbon command to the Quick Access toolbar, simply right-click its command button on the Ribbon and then click Add to Quick Access Toolbar on its shortcut menu. Excel then immediately adds the command button to the very end of the Quick Access toolbar, immediately in front of the Customize Quick Access Toolbar button.
If you want to move the command button to a new location on the Quick Access toolbar or group with other buttons on the toolbar, you need to click the Customize Quick Access Toolbar button and then click the More Commands option near the bottom of its drop-down menu.
Excel then opens the Excel Options dialog box with the Customize tab selected. Here, Excel shows all the buttons currently added to the Quick Access toolbar with the order in which they appear from left to right on the toolbar corresponding to their top-down order in the list box on the right-hand side of the dialog box.
To reposition a particular button on the bar, click it in the list box on the right and then click either the Move Up button or the Move Down button until the button is promoted or demoted to the desired position on the toolbar.
To remove a button added from the Ribbon, right-click it on the Quick Access toolbar and then click the Remove from Quick Access Toolbar option on its shortcut menu.
The Quick Access toolbar is a set of tools that the user can customize. By default, the Quick Access toolbar contains three tools: Save, Undo, and Redo. If you find that you use a particular Ribbon command frequently, right-click the command and select Add to Quick Access Toolbar. You can make other changes to the Quick Access toolbar from the Quick Access Toolbar tab of the Office (such as Excel or Words) Options dialog box. To access Continue reading ‘What Can You Customize In MS Office Ribbon And Quick Access Toolbar’ »
Over the time, you might be working on many different files in Excel. You may saved many different workbook in a folder or different path. So, there are chances you mess up and have no idea about the Excel file you opened.
Even if you never mess up and save a new workbook in the wrong folder, you might as well admit that eventually you’ll end up forgetting where you intentionally put some of them. Saving new file with summary information can help you quickly find and open any workbook that you’ve temporarily misplaced, regardless of the reason. Continue reading ‘How to Save New Excel File with Summary Information’ »
The following list of data-entry tips can help those moving up to Excel from another spreadsheet:
Here’s a quick summary of what’s new, relative to Excel 2007:
There four types of sheets available in Microsoft Excel: Worksheets, Chart sheets, MS Excel 4.0 macro sheets (obsolete, but still supported) and MS Excel 5.0 dialog sheets (obsolete, but still supported).
Worksheets
The most common type of sheet is a worksheet — which you normally think of when you think of a spreadsheet. Excel 2010 worksheets have Continue reading ‘Types of Excel Sheets’ »
An Excel workspace or sometimes known as an arranged workspace is a special file that keeps a record of all the workbooks open at the time you save the workspace, as well as all the workbooks’ screen attributes for example things like window sizes and arrangement, screen magnification, and any other display settings in use at the time.
Workspaces are timesavers because they enable Continue reading ‘What is Excel Workspace’ »
Excel 2 – 1987
The original version of Excel for Windows, Excel 2 first appeared in late 1987. It was labeled Version 2 to correspond to the Macintosh version, which was the original Excel. Because Windows wasn’t in widespread use at the time, this version included a runtime version of Windows — a special version with just enough features to run Excel and nothing else.
Excel 3 – 1990
This version offered a significant improvement in both appearance and features. It included toolbars, drawing capabilities, worksheet outlining, add-in support, 3-D charts, workgroup editing, and lots more.
Excel 4 – 1992
Excel 4 hit the streets in the spring of 1992. This version made quite an impact on the marketplace as Windows increased in popularity. It boasted lots of new features and usability enhancements that made it easier for beginners to get up to speed quickly. Continue reading ‘Microsoft Skip version 13th in Excel | Excel Versions History’ »