ExcelHub - Learn Excel Easily

Excel Tip #020 Keyboard shortcuts for formatting A lot of us use keyboard shortcuts but when it comes to formatting a spreadsheet, these shortcuts go for a toss as formatting relies on mouse. But there are few simple & effective shortcuts which would help us a lot. Below are some... CTRL+1 – Format anything This shortcut is powerful. Select anything (cells, chart objects, drawing shapes, pictures etc.) and press CTRL+1 to instantly launch format dialog box. ALT EST (or ALT HVE) – Format painter If you want to copy the formatting from one thing to another (like formatting of a bunch of cells to another range, a chart to another chart), you can use Format painter. Simply copy the original object (CTRL+C), select the target object and press ALT+EST (one key after another). You may also use ALT+HVE (again one key after another) in all modern versions of Excel. ALT HH – Fill color Now comes the tricky one. If you want to fill some color in a chart object, drawing shape,...

Excel Tip #010 Changing default chart color layout Whenever we want to use the chart series, Excel comes up with certain default colors to beautify the charts. It is high time we should know to change the default color layout and below is the same. To change the colors of the current workbook: On the Page Layout tab, in the Themes group, click Theme Colors Theme Colors under Page Layout tab Click Customize Colors Customize Colors option In the Create New Theme Colors dialog box, under Theme colors , click the button of the theme color element that you want to change Under Theme Colors , select the colors that you want to use Choosing colors for the new theme In the Create New Theme Colors dialog box, under Sample , you can see the effect of the changes that you make Repeat step 3 and 4 for all of the theme color elements that you want to change In the Name box, type an appropriate name for the new theme colors Click Save To revert all theme col...