A1 Paper Size Chart
| Paper Type | Size | Unit |
| A1 | 23.4 x 33.1 | Inch |
| A1 | 59.4 x 84.1 | cm |
| A1 | 594 x 841 | mm |
| A1 | 1684 x 2384 | Pixels (72 DPI) |
| A1 | 7016 x 9933 | Pixels (300 DPI) |
Team OfficeBeginner
How to Ungroup Worksheets in Excel
When you want to perform the same task on multiple worksheets in a workbook, you might have grouped them. Ungrouping is as easy as grouping them. If you’re struggling to ungroup the worksheets, you’re at the right place.
3 Methods of ungrouping worksheets in Excel:
- Click on any unselected sheet
- Keyboard keys and click on the grouped worksheets
- Select Ungroup Sheets
Let us begin.
How to Center Worksheets Horizontally in MS Excel
If you print a page in Microsoft Word, the content gets centered on the printed page automatically. But that is not the case with Microsoft Excel, as Microsoft Excel, by default, prints from the top-left corner of the page.
Why does Microsoft Excel do this? It is because, like most people, you enter data into the worksheet from cell A1. As a result, Excel replicates that into the printout. However, you can change that printing orientation. This article will discuss three methods of centering worksheets horizontally.
3 Methods of centering your worksheet horizontally in Microsoft Excel:
- Center the worksheet horizontally from the Print menu
- Center the worksheet horizontally using Custom Margins
- Center the worksheet horizontally using the Page Setup launcher tool
Let us begin.
How to Duplicate a Worksheet in MS Excel
If you want to create a new worksheet, you don’t have to start afresh. You can duplicate an existing worksheet and make changes to it.
For example, let’s imagine you want to make an invoice. Since it is time-consuming to write the document from scratch, you can instead duplicate an existing invoice and fill the copy with new details. In this article, we will discuss five methods of duplicating worksheets in Excel.
5 Methods of duplicating worksheets in Microsoft Excel:
- Duplicating worksheets within a workbook using the Format option
- Duplicating a worksheet to a different workbook
- Duplicating worksheets by right-clicking the worksheet tab
- Duplicating worksheets using the CTRL key
- Duplicating worksheets using VBA Macros
Let us begin.
How to Lock a Worksheet in MS Excel
Spreadsheets often contain sensitive data. If you share an unprotected spreadsheet with others, they may alter its contents. Sometimes, people may change the content of worksheets without intending to do so.
Both these scenarios will have unintended consequences. To prevent unwanted changes to a worksheet, you should be wise enough to lock it. This article will discuss five methods of protecting worksheet data in MS Excel by locking it.
5 Methods of locking worksheets in Microsoft Excel:
- Make the workbook read-only
- Lock the entire workbook
- Protect workbook structure using the Protect Workbook option
- Protect workbook structure using the Review tab
- Lock cells using the Format cells option
How to Count Unique Values in MS Excel
You might find yourself in a situation where you need to count the unique values in an MS Excel spreadsheet. This can be useful, especially when you have tons of data and there’s no way you can count them manually.
6 Methods to count unique values in MS Excel:
- Using the UNIQUE function
- Using the COUNTA function
- Using a pivot table
- Using SUM and COUNTIF function
- Using SUMPRODUCT and COUNTIF function
- Using the Remove Duplicates option
How to Create Postcards in MS Word
Postcards are an alternative way to communicate a message attractively. They are fun to make, and creating them in MS Word is easy.
2 ways to create Postcards in MS Word
- Using templates
- Using labels
We will show you both methods in simple, step-by-step instructions.
Let us begin.
How to Enable Dark Mode Microsoft Word
If you work during the day and night, staring at a bright screen in a dark room leads to eyestrain.
The latest versions of MS Word have a remedy for this. You can choose to switch MS Word to a dark mode. The palette will transform into darker colors, reducing eye strain in low ambient light settings.
2 ways to enable MS Word Dark Mode
- From the Account panes;
- From the Options dialog box.
In dark mode, you can toggle the background of a document from light to dark or reverse.
We will show you how to switch to a dark mode in MS Word in easy, step-by-step instructions.
Let us begin.
How to Set Custom Tab Stops in MS Word
In an MS Word document, you can turn on invisible characters. These invisible characters have different purposes. For example, a dot represents a single space. A pilcrow represents a new paragraph, while an arrow represents a tab stop.
A tab stop allows you to start (or end) text at a specified point on your page. You can read more about it in our ‘What are Tab Stops?’ article.
2 ways you can set invisible, custom, tab stops:
- Using the horizontal ruler.
- Using the Paragraphs menu.
We will show you in simple, step-by-step instructions how to set custom tab stops using both methods.
Let us begin.
How to Insert Today’s Date in MS Excel
3 Methods of inserting today’s date in MS Excel:
- Inserting today’s date in MS Excel using a keyboard shortcut
- Inserting today’s date in MS Excel using the TODAY function
- Inserting today’s date in MS Excel using the NOW function
We will explain these three methods in simple step-by-step instructions.
Let us begin.