![]() It Displays the drop-down menu for the corresponding smart tag. ![]() Inserts a new worksheet into the active workbook Insert Chart (It Creates a chart of the data in the current range)ħ. ALT + SHIFT + Function Keys Shortcut Shortcut Key Maximize or restore currently selected workbook windowĥ. SHIFT + Function Keys Shortcut Shortcut Keyĭisplays formula box to Paste function into the formulaĦ. ALT + Function Keys Shortcut Shortcut Key Minimize currently selected workbook window It will Unhide the rows in the current selectionĤ. CTRL + Function Keys Shortcut Shortcut Keyĭisplay Print Preview area on Print tab of Backstage ViewĪlternate between the currently active workbook window and the next workbook windowĪpply Move command on the active workbook windowĪpply Resize command on the active workbook window It Selects the current region (associated by blank rows and columns) It Enters the value from the cell directly above into the active cell It Unhides the columns in the current selection. ![]() (See Excel Personal Macro Workbook | Save & Use Macros in All Workbooks for info about PERSONAL.It is also used to switch between absolute/relative refs If you want to use the macro in multiple workbooks, save it in your personal macro workbook PERSONAL.XLSB. Save the workbook as a macro-enabled workbook and make sure that you allow macros when you open it. You can assign the macro to a Quick Access Toolbar button and/or a custom keyboard shortcut. Or you could copy the following macro into a module in the Visual Basic Editor: Sub AddBullets() ![]() You can then paste it in front of each line. You could insert one bullet, and copy the bullet and the space after it. So you'll have to insert a bullet in front of each line in a cell manually. It doesn't have built-in support for inserting bullets. Word, Excel is not a real text processor. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |