#HOW TO USE UP AND DOWN ARROWS IN EXCEL HOW TO#
Find out how to draw arrows in Photoshop if you have that program and a need to perform a similar action. I use a lot of arrows in the screenshots included on this site, and I typically add them in Photoshop. Step 5: Scroll down the list of symbols until you find the arrow that you want to use, click the desired arrow, then click the Insert button at the bottom of the window.ĭepending on the arrow you choose, your spreadsheet should them look something like the image below. Although helpful for a user viewing a large worksheet, its also quite annoying for those who have mistakenly enabled this feature. When the scroll lock feature is turned on, pressing an arrow key causes Microsoft Excel to move the entire spreadsheet, instead of moving to the next cell. Step 4: Click the Symbol button in the Symbols section at the right side of the ribbon. Excel up and down arrow keys move page instead of cell. Step 3: Click the Insert tab at the top of the window. Step 2: Select the cell into which you wish to insert the arrow. Step 1: Open your spreadsheet in Excel 2013. Pressing an arrow key while SCROLL LOCK is on will scroll one row up or down or one column left or right. Note: When SCROLL LOCK is on, Scroll Lock is displayed on the status bar in Excel.
There are several styles of arrows from which you can select. Press SCROLL LOCK, and then simultaneously hold down CTRL and an arrow key to quickly move through large areas of your worksheet. By completing the steps in this guide you will select a cell in your spreadsheet, then add an arrow to that cell. The steps in this article were performed in Microsoft Excel 2013. How to Add an Arrow to a Cell in Excel 2013
Our tutorial below will show you how to insert an arrow into a cell in Excel 2013. Whether this is to highlight a specific cell or row of data, an arrow can be a good way to draw the eye of your reader. The same goes for other common mathematical operations, as well as some advanced calculations that let you do things like combine data from multiple cells.īut sometimes you need to do something in Excel that doesn’t involve math or sorting, such as adding an arrow to one of your cells. If you want to subtract in Excel, there’s a formula that can help you do it.
0 kommentar(er)
