Quick Move to end of range of cells in Microsoft Excel

The tip submitted by Terry White, Birmingham, UK Instead of quickly move from a cell to the end of a range of cells by using Ctrl+Arrow, just s...

Hide and show outline symbol in Excel

In this article, we will learn How to use the ... function in Excel. Scenario: Applying SUBTOTAL option enables levels to the data. These Le...

Copying/Moving a Cell(s) Between Sheets/Workbooks

In this article, you’ll learn how to copy and move a cell(s) between sheets/workbooks in Microsoft Excel. We need to move or copy options for vario...

Select bottom right end corner of the used area Microsoft Excel

Tip submitted by Ajtoo From London Pressing the END key followed by the HOME key, takes you to the bottom right hand corner of the used area on...

Opening/Closing a Workbook(s)

Using keyboard shortcuts Opening a Workbook To open a new workbook: Press Ctrl+N. To open a recently saved workbook: Press Alt+F and then the...

Updating Charts by Dragging and Dropping in Microsoft Excel

If you have a chart with data for 1999 through 2001 and then enter a new column for 2002, you can drag and drop the new data on the chart. Highlight ...

How to use shortcut keys to move chart in Excel

In this article, we will learn How to use shortcut keys to move charts in Excel. Scenario: In excel, Charts are the best way to visualize an...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.