MS Excel Complete Course for Beginners Part 3
⌛Timestamps⌛
0:00 Intro
1:15 How to set a print area in Excel
3:15 Insert or delete rows and columns in Excel
5:00 Auto fill and flash fill in Excel
6:35 How to use the Format Painter in Excel
9:10 Wrap text within cell in Excel
10:30 Modify cell orientation in Excel
In Part 1 and Part 2 of the Beginner Excel series, we looked at how you can do a bunch of things in Excel, such as import data from CSV files, navigate to cells and named ranges, search for data within your Excel workbook, adjust the row height and column width, customize your header and footer, freeze worksheet rows and columns, and display all the formulas in your workbook. It’s time to take this a step forward and move on to more complex stuff that you can do in Excel. Specifically, in Part 3 we’ll look at how you can set a print area in Excel, insert or delete multiple rows or columns, fill cells by using autofill and flash fill, format cells quickly by using the Format painter, wrap text within cells, and modify cell alignment. Let’s get started.
How to set a print area in Excel
If you’ll be printing out any portion of your workbook, for example an invoice, then you must know how to set a print area in Excel. A print area is one or more ranges of cells that you designate to be printed. If you define a print area, then only that range of cells gets printed when you print out your Excel workbook. You can have more than one print area. When you print the Excel workbook, each print area gets printed on a separate page.
To specify a print area, first select the cells that you want to define as your print area. You can select more than one print area. To do so, hold the Ctrl key and select multiple areas.
After you’ve selected your print areas, go to the Page Layout menu. In the Page Setup group, click the down arrow icon next to Print Area, and choose Set Print Area. Excel will add borders around the areas that you’ve set as the print area. If you’ve added one or more print areas, and you want to add some more print areas, then you can continue selecting more cells or ranges, and then click the down arrow icon next to Print Area, and choose Add to Print Area.
There are two ways to view your print area. On the View menu, you can click on the Page Break Preview view. Excel will show your print areas with thick outside borders. Alternatively, you can go to File, Print, or hit Ctrl P or Cmd P on your keyboard to bring up the printing menu. Excel will display each print area as a separate page in the Print Preview window.
How to insert or delete multiple rows or columns in Excel
You’ll be working with a lot of data in Excel, so it’s important to know how to quickly insert or delete multiple rows or columns.
One way to quickly insert multiple rows is to select the number of rows that you want to insert, then right-click and choose Insert. To select a row, you can click the row number to the left. To select more than one row, use the Ctrl key on your keyboard.
You can also insert rows by going to the Insert menu, clicking Insert, and then clicking Insert Sheet Rows. Whenever you insert rows, the rows are added above the rows that you selected. For example, if you had selected 2 rows, then when you choose Insert, 2 blank rows are inserted above those two rows.
The method to insert columns is similar. Select the number of columns that you want to insert. You can do this by clicking the Column name to the top of the column. To choose more than one column, use the Ctrl key on your keyboard, then right click and choose Insert. You’ll also find a similar menu option in the Insert menu.
To delete rows, simply select the rows you want to delete, right-click and choose Delete.
Similarly, to delete columns, simply select the columns you want to delete, right-click and choose Delete.
How to fill cells by using autofill and flash fill
Excel gives you a bunch of options to quickly fill in data.
📺 W E B S I T E 📺
Https://WWW.PrasadHariharan.COM
Hindi channel: https://bit.ly/3wf9OK1
Buy me a COFFEE: [https://www.buymeacoffee.com/prasi55]
Patreon: [ / unleashyourproductivity ]
⚡ SUBSCRIBE! ⚡
My Hindi channel [https://bit.ly/3wf9OK1]
🌻 Links 🌻
🌈 E X C E L & G O O G L E S H E E T S🌈
[ • Microsoft Excel ]
[ • Microsoft Office ]
📚 M S O F F I C E 📚
[ • Google Sheets ]
📝 N O T E T A K I N G 📝
[ • Microsoft OneNote ]
Buy me a COFFEE: [https://www.buymeacoffee.com/prasi55]
Patreon: [ / unleashyourproductivity ]
"Copyright Disclaimer Under Section 107 of the Copyright Act 1976, the allowance was made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a copyright law that will otherwise be infringing. Non-profit, educational or personal use"
Смотрите видео MS Excel Complete Course for Beginners Part 3 онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Prasad Hariharan 01 Февраль 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 3 раз и оно понравилось людям.