Right-click on the sheet tab and select View Code.Insert a new worksheet at the beginning of your workbook and rename it Index.With the form in design view, follow these steps to make sure that data related to gender goes into the Gender field: One method for making this task easier is to build an index sheet that contains hyperlinks to every worksheet in your workbook.įor instance, suppose you want to ensure that the right data is entered in the Gender field. When working with large workbooks in Microsoft Excel, you can spend a good deal of time navigating through dozens of sheet name tabs to find the one you need. Use index sheets to quickly navigate in an Excel workbook If you just want to cycle through the available sizes without moving the cursor to the toolbar, press > to increase the font to the next larger size in the Size list box. You can even enter half-point sizes, such as 15.5. You can specify a size as small as 1 point or as large as 1638 points. If you already know what size you want your font to be, you can type the font size in the Size list box before pressing. Then, you can then press the up arrow or down arrow keys to cycle through the available font sizes, and press when you reach the font size you want. Using the Font menu or the Formatting toolbar to change a font size is fine if you only need to make a couple of font size changes in your Word document.īut, if you're trying out different font sizes to see which one looks best, keyboard shortcuts can make resizing text a little less cumbersome.įor example, pressing P moves your cursor to the font size box in the standard toolbar. Resize text in Word with keyboard shortcuts 41 impressive questions to ask in a job interview
0 kommentar(er)
