ALL YOU Need to Know About Excel HYPERLINKS (Function & Feature) Hyperlinks! They’re everywhere…even in Excel! “But Excel isn’t a Web browser. How can hyperlinks be of any value?” Here are the skills we will learn to take advantage of Excel hyperlinks:
GUESS what's HIDDEN in Excel? (Cool Trick) Who says Excel can’t be fun? We will show how you can bring some fun to your next meeting or lecture using only Excel and some creative uses of Excel features. We want to play
Lock Cells & Protect Worksheet EVEN by Cell Color! This post will demonstrate how to lock and unlock cells. That doesn’t sound like much to read about, but there’s a twist. We’re going to look at the basics of cell protection, which
SUPER EASY Excel Data Entry Form (NO VBA) In this post we will look at creating data entry forms in Excel. The best part is… NO VBA! Suppose you need to input data into an Excel table and you want to make
Why you SHOULD be USING Custom Number Formatting in Excel Let’s see a few Excel Custom Number Formatting tips that will not only save you time, but also help you avoid common spreadsheet mistakes. First, we’ll see the formatting in action and
Excel HACK: Change HORIZONTAL Data to VERTICAL (NO Transpose Function needed) Efficiency is a key objective here at XelPlus, but sometimes even the best of us miss the mark. In a previous post, we discussed three different ways to transpose data in
Excel shortcut keys you SHOULD know! This post‘s topic is one the most requested topics for the site. SHORTCUTS!!!! These are keyboard shortcuts that EVERY Excel user needs to know, practice, and commit to muscle memory. From the beginning Excel user to
Learning Custom Number Formatting – One of Excel’s Magical Mystery Tours Typing data in Excel can have the same result as typing a letter on a typewriter – what you see is what you get – commonly referred to as “WYSIWYG”. Unlike
3 Methods to Unhide All Sheets in Excel (& how to hide) How can you unhide all Excel sheets at once? Hiding many worksheets at once is easy in Excel. Click on a sheet, hold down the control or the shift key,
Better Excel Presentations: Increase Font Size of Formula Bar Imagine the following scenario: You’re in the audience of a presentation and the speaker is displaying a spreadsheet on a television or projector screen. The screen is full of facts, figures, and formulas.