Search
02
Aug

Maximizing Screen Space In Excel

It is remarkable how many repetitive actions we carry out in Excel spreadsheets, such as scrolling a worksheet from side-to-side when a couple of columns are off to the side of your screen. Commands on Excel’s View menu enable you to force an area of a worksheet to exactly fit onto your screen. A common scenario is a worksheet with twelve months of data, along with a total column. You might be able to see all the columns at once, or let’s say on a laptop screen you might see the data through November, and then have to scroll to the right to see December and the annual total. One screen-sizing approach involves using the Zoom Slider at the lower right-hand corner of the application window, as shown in Figure 1. I tend to turn this off because I find that I bump this control accidently when aiming for the horizontal scroll bar, sometimes resulting in microscopic print on-screen. To do so, right-click on the feature and then turn it off by way of the Customize Status Bar menu that appears. You can also use Zoom to Selection to make text larger. If you select a range of cells that is smaller than what you can see on screen, Excel will zoom in to make the selection fill your screen. Ostensibly, the Zoom Slider is a valid approach for fitting more information on the screen, but it is easy for this feature to run amok. Instead, the Zoom to Selection command will enable you to maintain better control: Select the cells that you wish to see onscreen, such as column A through N. Activate Excel’s View menu. Click Zoom to Selection. As shown, Excel will shrink everything to exactly fit onscreen. Click the 100% command on Excel’s View menu if you bump the Zoom Slider or wish to reverse the effects of Zoom to Selection. Figure 1: Excel’s Zoom to Selection command enables you to squeeze more information onto your screen.
28
Jul

Exclusive Excel Shortcut Hacks

MS Excel is undoubtedly the most popular software used for data analysis and handling. It enables professionals from different backgrounds to effortlessly manage data, big and small. Despite its popularity, however, there's a hidden treasure trove of functions and shortcuts that a large number of users are unaware of. These tips can make it easier to handle work and improve productivity several times over. Here are some simple yet effective functions in Excel: 1. Paste Special People often need to copy the content of one cell and paste it into another. But the data of a cell may have other attributes, such as formatting, value, formula, comments, and many more. To copy only certain characteristics, one can use the 'paste special feature. To use this feature, you need to go to the "Home" tab in the toolbar on the top left. You will find it under Clipboard. Right-click or press Ctrl+Alt+V. The Paste Special box offers various options like Paste Values, Paste Values, and Number Formats & Transpose. Paste Values: If you want the value of a cell and not the entire formula, go for Ctrl-Alt-V-V and hit enter. Do bear in mind, the default action of Excel is to copy a formula.  Paste Values and Number Formats: This transfers the format of the original cell. This feature is beneficial when you want to copy over dates or a currency and not the original formula of the cell. The shortcut for this is Ctrl+Alt+V+U & hit enter. Transpose: This enables you to flip rows and columns around in seconds. You can easily turn a row of numbers vertically or vice-versa by simply copying and then using Paste Special – Transpose. The shortcut for Transpose is Ctrl-Alt-V-E & hit enter. 2. Go To Special This feature allows you to locate and select cells of the same characteristics. You can select cells that have characteristics like comments, formulas and numbers. It will help you to identify errors or highlight content. It is in the Editing section under 'Find & Select.' The shortcut for this is Ctrl+G followed by Alt+S. For Instance, you have a column of cells with some blank cells which you wish to get rid of. First, select that column, then select Go To Special, then Blanks, and you'll see that all the blank cells are highlighted. Now, right-click on one and select Delete. All blank cells would be gone. The shortcut in excel for Go To Special, Blanks is Ctrl-G followed by Alt-S-K and hit the enter button. 3. Flash Fill Function Excel came up with a great feature in 2013. If you have two columns of names (first and last) and you require it to put both columns together. Type manually for the first row, and you will find the rest of it appear on its own. This makes dealing with names a lot easier and quicker. 4. Use of Apostrophe The apostrophe (') tells Excel to treat the data following it as it is and not to pick it up as a formula. If the first character in the cell is +, - and =. Excel treats the cell differently and starts looking for cells to refer to. This can be disorienting. That's where our next Excel hidden gem comes in. The apostrophe (') is Excel's solution to displaying data that Excel would otherwise treat differently. Apostrophe ensures data is displayed just the way it is entered. 5. F2 If you use Excel a lot, you will understand the frustration of looking for your cursor. To give reprieve to us all, Excel provides a nifty hack just to hit F2. This activates the cell you are working in. It will bring you directly to that cell.

Connect with Us

Copyright © 2024 Excel Accountant. All Rights Reserved.