Microsoft Office - Excel Archives

July 24, 2017 By yclmanager5

Cursors in Excel

Have you ever wondered what all the different cursors do in Excel? Here is a short video to show what they all do and where to place your cursor to achieve your desired task.

May 1, 2017 By yclmanager5

Shortcut to Time/Date Stamp in Microsoft Excel

Here is a quick short cut you can use to add a time and or date stamp into a cell in Excel. For a Date Stamp, first select your cell and then press CTRL+; (Control Key and the Semi Colon key). For the Time Stamp, once again select your cell and then press CTRL+ SHIFT+: (Control Key, Shift Key, and the Colon Key).

March 6, 2017 By yclmanager5

Move Between Different Open
Microsoft Office Files

When you have multiple spreadsheets open, it can take many clicks shifting between different files. In addition, you never want to end up entering information into the wrong file. Use Ctrl + Tab to shift between different files easily. The great part of this tip is that it also works in other programs as well like Firefox and Chrome while using Windows 7. You can easily shift between any open tabs!

January 9, 2017 By yclmanager5

Compare Documents in Microsoft Office

Tired of having to switch back and forth between documents when comparing data? There is tool you can use to have your documents side by side with a couple clicks.

First click on the View tab
Then click View Side by Side in the Window group
You can also stay at the same point on each spreadsheet by clicking Synchronous Scrolling.

Simple as that!

December 26, 2016 By yclmanager5

Linking Excel Data into a Word Document

This is a great tip that you can use especially if you use the same data in multiple places. Linking your information means, you only have to change it in one place. This video will show you how it is done.

December 5, 2016 By yclmanager5

Loose the Ribbon

Have you ever needed to look at your document with the least amount of distractions on your screen? By hiding the ribbon, you can see your document more clearly.

Press CTRL+F1 to hide the ribbon. To see it again press the same keys again or double click on the tab heading that you would like to use and you will be able to see the full ribbon again.

November 28, 2016 By yclmanager5

Highlighting with Keyboard Commands in Excel

There are much easier ways to select a group of data than using your mouse and dragging the cursor. Especially if your mouse occasionally tries to run away.

Depending on what you would like to highlight there are several different keyboard command that use the Shift key.

Press CTRL+ SHIFT and then press one of your arrow keys and it will select all the data in that row or column in the direction of the arrow key you pressed.
Press SHIFT and your arrow keys and you will be able to go cell by cell and select a very specific set of data.
Press CTRL+SHIFT+END and you will select from your selection point to the lowest right hand cell.
Press CTRL+SHIFT+* and you will select all the data in your document no matter where your selection point is.

October 17, 2016 By yclmanager5

Protect your Microsoft Excel Sheets

Do you have an Excel document that is shared between co-workers? But there is one sheet that you need to make sure isn’t edited. You can easily protect it by right clicking on the sheet tab and clicking “protect sheet.” In the new dialog box you can set a password and if you wish even specify further as to which cells can or cannot be edited.

October 10, 2016 By yclmanager5

Change the Defaults in Excel

If you use Excel often and are not a fan of the default settings it has set for the font and font size, you can change them and even change the default number of sheets it sets up in a new document! Here is how:

Click the File tab
Then click Options
Look in the pop up window under General
You can make all the changes you want to these default settings here

There are many things that you can do to make Microsoft Excel easier to use and changing your default settings is simple way to do this.

October 3, 2016 By yclmanager5

Find Out If Using an Excel Template Could Help You

There are many different projects that I have done in Microsoft Word where I have used Templates to save myself some extra work. But, did you know you can do the same thing in Excel? The next time you open up Excel click on the File tab and then New, and in the second half of your screen check out all the different templates you can use in Excel to help save you some time. There are templates to help save you time on business projects and personal ones alike. Budgets, invoices, and amortization schedules are just a few of the templates Excel has available. Depending on the template, some even have formulas already inserted and are ready for data to calculate.