Column addition worksheet: 2 Digit Addition Worksheets

Insert or delete rows and columns

Rows & columns

• 
  
  Insert or delete rows, and columns
  
  
  
  
  Article
  
  
• 
  
  Select cell contents in Excel
  
  
  
  
  Article
  
  
• 
  
  Freeze panes to lock rows and columns
  
  
  
  
  Article
  
  
• 
  
  Hide or show rows or columns
  
  
  
  
  Article
  
  
• 
  
  Filter for unique values or remove duplicate values
  
  
  
  
  Article
  
  
• 
  
  Split text into different columns with the Convert Text to Columns Wizard
  
  
  
  
  Article
  
  
• 
  
  Create a list of sequential dates
  
  
  
  
  Article
  
  

Next:


Cells

Insert and delete rows and columns to organize your worksheet better.

Note: Microsoft Excel has the following column and row limits: 16,384 columns wide by 1,048,576 rows tall.

Insert or delete a column

1. Select any cell within the column, then go to Home > Insert > Insert Sheet Columns or Delete Sheet Columns.

2. Alternatively, right-click the top of the column, and then select Insert or Delete. 

Insert or delete a row

org/ItemList»>

1. Select any cell within the row, then go to Home > Insert > Insert Sheet Rows or Delete Sheet Rows.

2. Alternatively, right-click the row number, and then select Insert or Delete.

Formatting options

When you select a row or column that has formatting applied, that formatting will be transferred to a new row or column that you insert. If you don’t want the formatting to be applied, you can select the Insert Options button after you insert, and choose from one of the options as follows:

If the Insert Options button isn’t visible, then go to File > Options > Advanced > in the Cut, copy and paste group, check the Show Insert Options buttons option.

Insert rows

To insert a single row: Right-click the whole row above which you want to insert the new row, and then select Insert Rows.

To insert multiple rows: Select the same number of rows above which you want to add new ones. Right-click the selection, and then select Insert Rows.

Insert columns

To insert a single column: Right-click the whole column to the right of where you want to add the new column, and then select Insert Columns.

To insert multiple columns: Select the same number of columns to the right of where you want to add new ones. Right-click the selection, and then select Insert Columns.

Delete cells, rows, or columns

If you don’t need any of the existing cells, rows or columns, here’s how to delete them:

1. Select the cells, rows, or columns that you want to delete.

2. Right-click, and then select the appropriate delete option, for example, Delete Cells & Shift Up, Delete Cells & Shift Left, Delete Rows, or Delete Columns. 

When you delete rows or columns, other rows or columns automatically shift up or to the left.

Tip: If you change your mind right after you deleted a cell, row, or column, just press Ctrl+Z to restore it.

Insert cells

To insert a single cell:

1. Right-click the cell above which you want to insert a new cell.

2. Select Insert, and then select Cells & Shift Down.

To insert multiple cells:

org/ItemList»>

1. Select the same number of cells above which you want to add the new ones.

2. Right-click the selection, and then select Insert > Cells & Shift Down.

Need more help?

You can always ask an expert in the Excel Tech Community or get support in the Answers community.

See Also

Basic tasks in Excel

Overview of formulas in Excel

How to compare two Excel files or sheets for differences

In this tutorial, you will learn a variety of methods to compare Excel files and identify differences between them. See how to open two Excel windows side by side, how to use Excel formulas to create a difference report, highlight differences with conditional formatting, and more.

When you have two similar Excel workbooks, or better say two versions of the same workbook, what’s the first thing you usually want to do with them? Right, compare those files for differences, and then probably merge them into a single file. In addition, workbook comparison can help you spot potential problems like broken links, duplicate records, inconsistent formulas or wrong formatting.

So, let’s have a closer look at various methods to compare two Excel sheets or entire workbooks and identify differences between them.

How to compare two Excel files by viewing them side by side

If you have relatively small workbooks and a sharp eye for detail, this quick and easy way to compare Excel files might work well for you. I am talking about View Side by Side mode that lets you arrange two Excel windows side by side. You can use this method to visually compare two workbooks or two sheets in the same workbook.

Compare 2 Excel workbooks

Let’s say you have sales reports for two months and you want to view both of them simultaneously to understand which products performed better this month and which did better last month.

To open two Excel files side by side, do the following:

1. Open the workbooks you want to compare.
2. Go to the View tab, Window group, and click the View Side by Side button. That’s it!

By default, two separate Excel windows are displayed horizontally.

To split Excel windows vertically, click Arrange All button and select Vertical:

As the result, two separate Excel windows will be arranged side by side, like in the below screenshot.

If you want to scroll through both worksheets simultaneously to compare data row-by-row, make sure the Synchronous Scrolling option it turned on. This option resides on the View tab, in the Window group, right under the View Side by Side button, and is usually turned on automatically as soon as you activate View Side by Side mode.

For more information about using this Excel feature, please see View Excel workbooks side by side.

Arrange multiple Excel windows side by side

To view more than 2 Excel files at a time, open all the workbooks you want to compare, and click the View Side by Side button. The Compare Side by Side dialog box will appear, and you select the files to be displayed together with the active workbook.

To view all open Excel files at a time, click the Arrange All button on the View tab, in the Window group, and choose your preferred arrangement: tiled, horizontal, vertical or cascade.

Compare two sheets in same workbook

Sometimes, 2 sheets that you want to compare reside in the same workbook. To view them side by side, perform the following steps.

1. Open your Excel file, go to the View tab > Window group, and click the New Window button.
2. This will open the same Excel file in a different window.
3. Enable View Side by Side mode by clicking the corresponding button on the ribbon.
4. Select sheet 1 in the first window and sheet 2 in the second window.

How to compare two Excel sheets for differences in values

It is the simplest way to compare data in Excel that lets you identify cells with different values. As the result, you will have a difference report in a new worksheet.

To compare two Excel worksheets for differences, just open a new empty sheet, enter the following formula in cell A1, and then copy it down and to the right by dragging the fill handle:

=IF(Sheet1!A1 <> Sheet2!A1, "Sheet1:"&Sheet1!A1&" vs Sheet2:"&Sheet2!A1, "")

Due to the we use of relative cell references, the formula will change based on a relative position of the column and row. As the result, the formula in A1 will compare cell A1 in Sheet1 and Sheet2, the formula in B1 will compare cell B1 in both sheets, and so on. The result will look similar to this:

As you can see in the above screenshot, the formula compares 2 sheets, identifies cells with deferent values and displays the differences in corresponding cells. Please note that in the difference report, dates (cell C4) are presented by serial numbers as they are stored in the internal Excel system, which is not very convenient for analyzing differences between them.

Highlight differences between 2 sheets with conditional formatting

To highlight cells that have different values in two sheets with the color of your choosing, use the Excel conditional formatting feature:

As the result, the cells with different values will get highlighted with the selected color:

If you are not very familiar with Excel conditional formatting, you can find the detailed steps to create a rule in the following tutorial: Excel conditional formatting based on another cell value.

As you see, it’s very easy to compare two Excel sheets by using formulas or conditional formats. However, these methods are not well suited for all-round comparison because of the following limitations:

• They find differences only in values, but cannot compare formulas or cell formatting.
• They cannot identify added or deleted rows and columns. As soon as you add or delete a row / column in one sheet, all subsequent rows / columns will be marked as differences.
• They work on a sheet level, but cannot detect workbook-level structural differences such as sheet additions and deletions.

Compare and merge copies of a shared workbook

When it comes to merging different versions of the same Excel file, the Compare and Merge feature comes in handy. It is especially useful when several users collaborate on the same Excel workbook because it lets you view the changes and comments of all users at a time. To leverage this feature, be sure to do the following preparations:

• Share your Excel workbook before you make it available to other users.

  To share a workbook, just click the Share Workbook button on the Review tab, in the Changes group, select the Allow Changes by More Than One User… box, and click OK. Allow Excel to save the workbook if prompted. Turning on the Track Changes feature shares the workbook automatically.

• Each person who makes any edits to the shared workbook must save a copy (.xls or xlsx file) using a unique file name.

Now that all initial preparations are done properly, you are ready to combine the copies of a shared workbook.

1. Enable the Compare and Merge Workbooks feature in your Excel

Although, the Compare and Merge Workbooks feature is available in all versions of Excel 2010 through Excel 365, this command is not displayed anywhere in Excel by default. To add it to the Quick Access toolbar, perform the following steps:

• Open the Quick Access drop down menu and select More Commands.
• In the Excel Options dialog box, select All Commands under Choose commands from.
• In the list of commands, scroll down to Compare and Merge Workbooks, select it and click the Add button to move it to the right-hand section.
• Click OK.

2. Compare and merge workbooks

When all of the users have finished working with your shared Excel workbook, you can merge all the copies into one file.

• Open the primary version the shared workbook.
• Click the Compare and Merge Workbooks command on the Quick Access toolbar.
• In the dialog box that appears, select a copy of the shared workbook that you want to merge. To select several copies, hold the Shift key while clicking the file names, and then click OK.

Done! The changes from each copy are merged into a single workbook.

3. Review the changes

To see all the edits by different users at a glance, just do the following:

• Switch to the Review tab > Changes group, and click Track Changes > Highlight Changes.
• In the Highlight Changes dialog, select All in the When box, Everyone in the Who box, clear the Where box, select the Highlight changes on screen box, and click OK.

To point out the row and columns with differences, Excel highlights the column letters and row numbers in a dark red color. At the cell level, edits from different users are marked with different colors. To see who made a specific change, just hover over the cell.

Note. If the Compare and Merge Workbooks command is greyed out in your Excel, most likely you are trying to combine different Excel files. Please remember, the Compare and Merge Workbooks feature allows merging only copies of the same shared workbook.

Third-party tools to compare Excel files

As you have just seen, Microsoft Excel provides a handful of features to compare data in two or more workbooks. But none of the built-in options is sufficient to comprehensively compare Excel sheets, let alone entire workbooks, spotting all the differences in values, formulas or formatting.

So, if you need advanced and really efficient means to compare two Excel files, then most likely you would have to use one of the third-party tools specially designed for comparing, updating and merging Excel sheets and workbooks. Below you will find a quick overview of a few tools that, in my opinion, are best performers in this area.

• Synkronizer Excel Compare
• Ablebits Compare Sheets for Excel
• xlCompare
• Change pro for Excel

Synkronizer Excel Compare: 3-in-1 tool to compare, merge and update Excel files

The Synkronizer Excel Compare add-in can quickly compare, merge and update two Excel files saving you the trouble of searching for differences manually.

If you are looking for a quick and reliable method to compare two Excel sheets or workbooks, you will certainly find helpful the following features of Synkronizer Excel Compare:

• Identifying the differences between two Excel sheets.
• Combining multiple Excel files into a single version without producing unwanted duplicates.
• Highlighting the differences in both sheets.
• Showing only the differences that are relevant to your task.
• Merging and updating the sheets.
• Presenting detailed and easy to read difference reports.

To get some basic idea about Synkronizer Excel Compare’s capabilities and performance, let’s carry out a couple of field tests.

Compare two Excel files for differences

Supposing you are organizing some event and, in your Excel table, you gather information about the participants such as a participant name, arrival date, number of seats, etc. Also, you have a couple of managers in direct contact with participants and the database, and as a result, you have 2 versions of the same Excel file.

Okay, let’s see how efficiently Synkronizer can compare our two sheets and identify differences between them.

To run Synkronizer Excel Compare, go to the Add-ins tab, and click the Synchronizer 11 icon.

The Synkronizer pane will show up in the left part of your Excel window, where you do the following:

1. Select 2 workbooks to compare:
2. Select sheets to compare.

   If the selected workbooks have any sheets with the same names, all those sheets will be matched and automatically selected for comparison (like Participants sheets in the below screenshot).

   Also, you can select worksheets manually or instruct the add-in to match sheets by other criteria, for example by worksheet type — all, protected, or hidden.

   Once you’ve selected the sheets, the Synkronizer add-in will open them side by side, arranged vertically or horizontally, like in Excel’s View Side by Side mode.

3. Select one of the following comparison options:
   • Compare as normal worksheets — the default option that works in most cases.
   • Compare with link options — if the selected sheets do not contain any new or deleted rows and columns, you can compare them «1 on 1».
   • Compare as database — recommended for comparing sheets that have a database structure.
   • Compare selected ranges — if you do not want to compare the entire sheets, define the ranges to be compared.
4. Choose the content types to be compared (optional).

   On the Select tab, in the Compare group, you can choose the content type(s) relevant to your current task:

   • Under Content, you can select comments and names (in addition to cell values, formulas and calculated values that are compared by default).
   • Under Formats, you choose what cell formats such as alignment, fill, font, border etc.
   • The Filters option lets you filter out differences that you don’t want to display. For example, you can ignore case, leading or trailing spaces, all formulas or different formulas with the same result, hidden rows or column, and more.
5. Finally, click the big red Start button on the ribbon and proceed to examining the results.

Visualizing and analyzing the differences

Usually it takes Synkronizer only a few seconds to compare 2 sheets and present two summary reports on the Results tab:

• In a summary report, you can see all difference types at a glance: changes in columns, rows, cells, comments, formats, and names.
• To view the detailed difference report, just click a specific difference type on the summary report.

The following screenshot shows the summary report (in the upper part of the Results pane), and cell difference report (in the lower part of the pane) that were created for our sample sheets:

Clicking on a difference in the detailed report will select the corresponding cells on both sheets (the below screenshot shows just one sheet because there’s enough room to show both 🙂

In addition, you can create a difference repot in a separate workbook, either standard or hyperlinked, and jump to a specific difference with a mouse click:

Compare all sheets in two workbooks at a time

If the two Excel files you are comparing contain multiple sheets, all matching worksheet pairs will be presented in the summary report for your perusal:

Highlighting differences between sheets

By default, the Synkronizer Excel Compare add-in highlights all found differences, like in the following screenshot:

• Yellow — differences in cell values
• Lilac — differences in cell formats
• Green — inserted rows

To highlight only the relevant differences, click the Outline button on the Results tab, and select the required options:

Update and merge sheets

The merge function is definitely one of the most useful features of the Synkronizer Excel Compare add-in. You can transfer individual cells or move different columns/rows from the source to target sheet, and have your primary sheet updated in seconds.

To update one or more differences, select them on the Synkronizer’s pane and click one of the 4 update buttons — the first and last buttons update all differences, while the 2^nd and 3^rd buttons update selected differences only (the button arrows indicate the transfer direction):

Well, these are the key features of the Synkronizer add-in, but there is certainly much more to it. Want to give it a try? An evaluation version is available for download here.

Synkronizer is certainly worth your attention, but it’s not the only way to compare files in Excel. A handful of other comparison tools exist, which basically provide the same set of features but in different implementations.

Ablebits Compare Sheets for Excel

The latest version of our Ultimate Suite includes over 40 new features and improvements, the most exciting of which is Compare Sheets — our own tool to compare worksheets in Excel.

To make the comparison more intuitive and user-friendly, the add-in is designed in this way:

• A step-by-step wizard walks you through the process and helps configure different options.
• You can choose the comparison algorithm best suited for your data sets.
• Instead of a difference report, the compared sheets are displayed in the Review Differences mode so that you could view all the differences at a glance and manage them one-by-one.

Now, let’s try the tool on our sample spreadsheets from the previous example and see if the results are any different.

1. Click the Compare Sheets button on the Ablebits Data tab, in the Merge group:
2. The wizard will show up asking you to select the two worksheets you’d like to compare for differences.

   By default, the entire sheets are selected, but you can also select the current table or a specific range by clicking the corresponding button:

3. On the next step, you select the comparison algorithm:
   • No key columns (default) — works best for sheet-based documents like invoices or contracts.
   • By key columns — is appropriate for column-organized sheets that have one or more unique identifiers such as order numbers or product ID’s.
   • Cell-by-cell — best to be used to compare spreadsheets with the same layout and size, like balance sheets or year-to-year reports.

   Tip. If you are unsure which option is right for you, go with the default one (No key columns). Whichever algorithm you select, the add-in will find all the differences, it will only highlight them differently (entire rows or individual cells).

   On the same step, you can choose the preferred match type:

   • First match (default) — compare a row in Sheet 1 to the first found row in Sheet 2 that has at least one matching cell.
   • Best match — compare a row in Sheet 1 to the row in Sheet 2 that has the maximum number of matching cells.
   • Full match only — find rows in both sheets that have exactly the same values in all the cells, and mark all other rows as different.

   In this example, we will look for Best match by using the default No key columns comparing mode:

4. Finally, specify which differences to highlight and which to ignore, and how to mark the differences.

   Cell formatting is important to us, so we select Show differences in formatting. Hidden rows and columns are irrelevant, and we tell the add-in to ignore them:

5. Click the Compare button and allow the add-in a couple of minutes to process your data and make the backup copies. Backups are always created automatically, so you may not worry about the safety of your data.

Review and merge differences

Once the worksheets are processed, they are opened side-by-side in a special Review Differences mode, with the first difference selected:

On the screenshot above, the differences are highlighted with the default colors:

• Blue rows — rows that exist only in Sheet 1 (on the left).
• Red rows — rows that exist only in Sheet 2 (on the right).
• Green cells — difference cells in partially matching rows.

To help you review and manage the differences, each worksheet has its own vertical toolbar. For the inactive worksheet (on the left) the toolbar is disabled. To enable the toolbar, just select any cell in the corresponding sheet.

By using this toolbar, you go through the found differences one-by-one and decide whether to merge or ignore them:

As soon as the last difference is dealt with, you will be prompted to save the workbooks and exit the Review differences mode.

If you have not finished processing the differences yet but would like to take a break for now, click the Exit Review Differences button at the bottom of the toolbar and choose either to:

• Save the changes you’ve made and remove the remaining difference marks, or
• Restore the original workbooks from the backup copies.

That’s how you compare two sheets in Excel with our tool (hope you liked it 🙂 If you are curious to give it a shot, an evaluation version is available for download here.

xlCompare: compare and merge workbooks, sheets and VBA projects

Using the xlCompare utility, you can compare two Excel files, worksheets, names and VBA Projects. It identifies added, deleted and changed data and allows you to quickly merge differences. In addition, it provides the following options:

• Find duplicate records between two worksheets and remove them.
• Update all existing records in one sheet with values from another sheet.
• Add unique (new) rows and columns from one sheet to another.
• Merge all updated records from one workbook to another.
• Sort data on the sheets by the key column.
• Filter the comparison results to display differences or identical records.
• Highlight comparison results with colors.

Change pro for Excel: compare Excel sheets on desktop and mobile devices

With Change pro for Excel, you can compare two sheets in desktop Excel as well as on mobile devices with optional server-based comparison. The key features of this tool are:

• Find differences between 2 sheets in formulas and values.
• Identify layout changes, including added / deleted rows and columns.
• Recognize embedded objects such as charts, graphs and images.
• Create and print difference reports of formula, value and layout differences.
• Filter, sort, and search the difference report on key changes.
• Compare files directly from Outlook or document management systems.
• Support for all languages, including multi-byte.

Online services to compare Excel files

Apart from desktop tools and utilities, there exist a number of online services that let you quickly compare two Excel sheets for differences without installing any software on your computer. Probably it’s not the best solution in terms of security, but if your Excel files do not contain any sensitive information why not use some free online service for immediate results?

For example, you can try XLComparator or CloudyExcel, or find some other similar services on the net. This is how the CloudyExcel service looks like:

You just upload the two Excel workbooks you want to compare, and click the Find Difference button at the bottom of the screen. In a moment, the differences in two active sheets will get highlighted with different colors:

Well, this is how you can compare Excel files for differences. If none of the solutions described in this tutorial is suitable for your task, check out the following resources that cover other aspects of Excel file comparison. And if you know any other ways to compare two Excel files, your comments will be greatly appreciated. I thank you for reading and hope to see you on our blog next week!

Other ways to compare and merge data in Excel

How to add a column in Excel. Adding a new column, 2 columns and a column at the end of the table

Author Elizaveta KM Reading 9 min Published 01/01/2021

Adding new columns to a table is an important skill that every Excel spreadsheet user should have. Without this skill, it is impossible to work effectively with tabular data. In this article, we will look at many useful ways to create additional columns on the worksheet of a document.

Contents

1. Adding a new column
2. Method 1: Inserting a column using the coordinate bar
3. Method 2: Adding a column using the cell context menu
4. Method 3: Inserting using the ribbon tools
5. Method 4. Hotkeys for inserting a new column
6. Inserting two or more columns
7. Inserting a column at the end of a table
8. How to insert a column between columns in Excel?
9. Insert multiple columns between columns at the same time
10. Conclusion

Adding a new column

There are several options for adding a new column to a worksheet. Each of the methods below is very easy to perform, so even a beginner can handle them. Let’s consider each method in more detail.

Method 1. Inserting a column through the coordinate bar

This method is the easiest and most convenient to use. It implements the addition of a new column or an additional row to the tabular data. The walkthrough is as follows:

1. Find the coordinate bar of the horizontal type and click on the name of the column from which we want to add a new column. After carrying out this procedure, the entire column will be highlighted on the worksheet.

1

2. Right click on any area of ​​the selected fragment. A small context menu was displayed on the screen. We find an element called «Insert» and click on it with the left mouse button.

2

3. Done! We implemented the addition of a new empty column to the left of the column that was originally selected.

3

Method 2. Adding a column using the context menu of a cell

This method, like the previous one, involves using the context menu, but here not the entire column is selected, but only one cell. The walkthrough looks like this:

1. Select the cell to the left of which we plan to create an additional column. The selection is made using the left mouse button or the arrows on the keyboard.

4

2. Right click on the selected cell. The familiar context menu was displayed on the screen. We find the element «Insert …» and click on it with the left mouse button.

5

3. A small window appears on the display, in which you must specify which element will be added to the plate. There are three types of element: cell, row and column. We put a mark near the inscription «Column». After carrying out all the manipulations, click the «OK» button, located at the bottom of the window.

6

4. Done! We implemented the addition of a new empty column to the left of the column that was originally selected.

7

Method 3: Insert using the tools on the ribbon

On the ribbon, located at the top of the Excel spreadsheet interface, there is a special element that allows you to insert a new column into the table. The walkthrough looks like this:

1. Select the cell to the left of which we plan to create an additional column. The selection is made using the left mouse button or the arrows on the keyboard.

8

2. Move to the «Main» section, which is located at the top of the spreadsheet interface. Expand the list of the «Insert» element. In the list that opens, find the button «Insert columns on the sheet» and click on it.

9

3. Done! We implemented adding a new empty column to the left of the column that was originally selected

10

Method 4. Hot keys for inserting a new column

Using hot keys is another method that is very popular among advanced Excel spreadsheet users. There are two variations of this method. The step by step guide for the first method is as follows:

1. Click on the name of the column on the coordinates panel.

Remember! An additional column is always added to the left of the selected column.

2. Press the key combination on the keyboard «Ctrl» + «+». After carrying out all the manipulations, a new column will appear to the left of the selected column.

11

The step-by-step guide for the second method is as follows:

1. Click on the cell with the left mouse button.
2. Press the key combination on the keyboard «Ctrl» + «+».
3. The familiar window called “Add Cells” was displayed on the screen. We put a fad near the inscription «Column». After carrying out all the manipulations, click the «OK» button, located at the bottom of the window.

12

4. Done! After carrying out all the actions to the left of the selected column, a new column will appear.

13

Inserting two or more columns

There are situations when a spreadsheet user needs to insert several additional columns at once. The functionality of the program makes it easy to do this. The walkthrough is as follows:

1. Initially, we select cells horizontally. You need to select as many cells as you want to add additional columns.

Please note! And it doesn’t matter where the selection is made. You can select cells both in the table itself and in the coordinate panel.

14

2. Using the instructions above, we proceed to add additional columns. In our particular example, we opened the context menu with the right mouse button and selected the «Insert» element.

15

3. Done! We implemented the addition of new empty additional columns to the left of those columns that were originally selected.

16

Inserting a column at the end of a table

All methods above are only suitable for those situations where you need to add one or more additional columns to the middle or beginning of a plate located on the document worksheet. Of course, using these methods, you can add new columns to the end of the table, but then you will have to spend a lot of time editing it.

There is one useful method for inserting new columns into the table without additional formatting. It consists in the fact that the standard plate turns into a «smart» one. The walkthrough looks like this:

1. We make a selection of absolutely all the cells of our table. There are many ways to highlight all data. We will use the key combination on the keyboard «CTRL + A».

17

2. Move to the «Main» section, which is located at the top of the interface. We find the block of commands «Styles» and click on the element «Format as table».

18

3. A list with styles has been opened. We select the appropriate style for the «smart table» by pressing the left mouse button.

19

4. A small window called «Format Table» was displayed on the screen. Here you need to specify the boundaries of the selected area. With the correct initial selection, there is no need to change anything here. If you notice incorrect data, you can edit it. Put a checkmark next to the element «Table with headers». After carrying out all the manipulations, click on the «OK» button.

20

5. As a result of our manipulations, the original plate turned into a “smart” one.

21

6. All we have to do is add a new column to the end of the table. We simply fill in the necessary information with any cell located to the right of the «smart» table. The column filled with data will automatically become an element of the «smart table». All formatting will be preserved.

22

How to insert a column between columns in Excel?

Now let’s talk in more detail about how to insert a column between other columns in an Excel spreadsheet. Let’s take a look at a specific example. For example, we have some price list with missing item numbering. We need to add an additional column between the columns in order to fill in the price list item numbers. There are two methods to implement this procedure.

23

The step by step guide for the first method is as follows:

1. Move the mouse pointer to cell A1 and select it.
2. Moving to the «Home» section, which is located at the top of the spreadsheet interface. We find a block of commands called «Cells» and select the «Insert» element.
3. A small list has been opened, in which you need to select the item «Insert columns on sheet».

24

4. Done! We have implemented the addition of a new empty additional column between the columns.

The step-by-step guide for the second method is as follows:

1. Right-click on column name A.
2. A small context menu is displayed on the screen, in which you need to select an item called «Insert».

25

3. Done! We have implemented the addition of a new empty additional column between the columns.

After using one of the two methods described above, we can start filling the created column with the numbers of the price list items.

Inserting multiple columns between columns at the same time

Continuing with the price list example above, let’s see how multiple columns are added between columns at the same time. The price list lacks 2 columns: quantities and units of measurement (pieces, kilograms, liters, packages, and so on). The step-by-step guide is as follows:

1. To add two additional columns, we need to select a range of 2 cells. We allocate C1:D

26

2. Move to the «Main» section, which is located at the top of the spreadsheet interface. We find a block of commands called «Cells» and select the «Insert» element. A small list has opened, in which you need to select the «Insert columns on sheet» item.
3. Done! We have implemented adding two columns between two columns.

There is an alternative way to perform this procedure. The walkthrough is as follows:

1. Select two column headings C and D.
2. Click the right mouse button. The familiar context menu opens. We find an element called «Insert» and click on it with LMB.

27

3. Done! We have implemented adding two columns between two columns.

Sometimes it happens that the user, while working with tabular information, accidentally adds an unnecessary column. Let’s figure out how to perform the removal procedure. The walkthrough is as follows:

1. Select the range of cells whose columns we plan to delete.
2. We move to the «Home» section, find the «Delete» block and click on the element called «Delete columns from the sheet.» Alternatively, right-click to open the context menu and select the «Delete» item.
3. Done! We have implemented the removal of unnecessary columns from tabular data.

Important reminder! Additional columns are always added to the left of the selected columns. The number of new columns depends on the number of columns originally allocated. The order of the inserted columns depends on the selection order (through one and so on).

Conclusion

The Excel spreadsheet has a huge number of ways to add additional columns to any place in the spreadsheet. Converting the source data into a «smart table» allows you to insert additional columns without wasting time on formatting, since the appearance of the new columns will take on the finished table formatting. A wide variety of methods for adding columns allows each user to choose the most convenient one for themselves.

Rate the quality of the article. Your opinion is important to us:

Adding a cell, row, column

264. Adding a cell, row, column

265. Yes
     insert empty cells, rows and columns
     and fill them with data. If cells
     moved or copied, they can be
     insert between existing cells,
     so as not to erase the already entered
     information.

266. Before
     by executing the add cells command
     should highlight the range in which
     new cells should be placed. His
     the size must match the quantity
     inserted cells. Add command
     empty cells is performed through the panel
     Cells/Insert
     tabs Home .
     In the dialog box that opens Adding
     cells selectable
     one of the switches: cells, co
     right shift or cells, shifted
     down (Fig. 3.6).

267. Similar
     the result will be obtained by choosing
     context menu item Insert …
     

269. Fig.
     3.6.
     Dialog box Adding
     cells

270. For
     adding one line stands out
     the cell in the row above which
     insert a new line and in the tool
     Insert
     command is selected Line .
     To insert multiple lines,
     lines are highlighted, above which
     insert newlines. Quantity
     selected and inserted rows should
     coincide.

271. Insert
     lines can be through the context menu
     Addendum
     cells
     (Fig. 3.6). In this case, you need to put
     switch to position line .
     After pressing the OK button, the
     new line.

272. For
     adding one column stands out
     the cell in the column to the left of which
     a new column should be placed. Further
     actions are performed as if adding
     rows, but command Column is selected
     (fig.3.6).

273. Practical
     reference

274. 1.
     Go to Sheet 2 of your document.

275. 2.
     Type in cell B4
     number 1, in cell C4 — number 2, in cell
     D4
     – number 3.

276. 3.
     Insert two empty cells before a cell
     C4.

277. 4.
     Add three lines like this
     to address cell B4,
     into which the number 1 is entered has changed to
     B7.

278. 5.
     Add an empty column between cells
     with numbers 2 and 3.

279. 6.
     Save your changes.

281. deleting cell Microsoft
     Excel
     moves neighboring cells so that
     they filled the empty space.
     When a cell is cleared, it is deleted
     content (formulas and data), formats
     (including numeric, conditional formats, and
     borders) and notes, but empty cells
     remain on the sheet.

282. Delete
     selected cells, rows and columns
     can be in the panel Cells / Delete
     or in the context menu Delete .
     After selecting this command, it will open
     dialog box Deletion of cells , in
     which should select the desired
     switch and click OK.

283. Features
     columns and rows

284. columns can be resized, rows
     — height. Column and row can be hidden
     and display.

285. Change
     the width of the selected columns can be one
     of the following ways:

• move
  mouse right border of the title of any
  from selected columns until
  they will not reach the required dimensions.
  The mouse pointer will change to
  bidirectional
  arrow

• twice
  click on column address
  the column width will automatically
  content adjusted

• set
  parameter Widths
  column on tab Home
  using tool group Cells .
  Command Cells/Format/Height
  lines .

286. Same
     line height is adjusted.

287. If
     when calculating in a cell instead of a number
     ##### appears, which means that
     the result does not fit in the cell and its
     width needs to be increased.

288. Command
     Cells/Format/Visibility allows
     hide or show selected
     column or row.

290. Practical
     reference

291. 1.
     Change the width of column B according to the contents of cell B4,
     set column C to a width
     10.

292. 2.
     Change the height of the second line.

293. 3.
     Hide and show column B.

294. 4.
     Save your changes.

296. Cell fusion

297. Cell fusion
     cells are used if necessary
     put text in multiple columns.
     In the merged cell , Microsoft Excel puts only the data of the upper left
     angle from the selected range. For
     inclusion in the combined cell of all
     range data to be copied
     all the data in the top left cell inside
     range.

298. For
     merging cells and aligning
     cell content center should be clicked
     button: Combine and place in
     center on panel

299. Alignment
     tabs home .

300. Combine
     all selected cells in a row, or
     column, you can use the command
     Cells/Format/Format cells then
     in the dialog box, go to the tab Align and check the box merge cells .

302. Practical
     task

1. Swipe
   union of all cells in the range B2:D4.

2. Cancel
   completed merging.

304. Worksheet

305. Worksheet
     sheets can be added, removed,
     rename, copy, move
     and hide. Command Cells/Format/Visibility
     allows you to hide or show
     selected sheet.

306. Addendum
     new worksheet

307. Insert
     new sheet is done using
     context menu commands Insert .
     In the opened dialog box Insert select the type of sheet to be inserted.
     The context menu is called on the label
     the sheet before which you want
     insert a new sheet.

308. Add
     one sheet is possible with the command
     Insert/Insert Sheet Panel Cells Tabs Home . To
     insert multiple sheets, selectable
     required number of sheets by holding
     pressed the SHIFT key, then executes
     team Insert/Insert Sheet .

310. Practical
     reference

311. 1.
     Add a new sheet between sheets
     «Sheet1» and «Sheet2».

312. 2.
     Save your changes.

313. Delete sheet

314. Delete
     selected worksheet is carried out
     context menu command — Delete .
     You can also delete a sheet with the command — Delete /
     Delete sheet panel Cell tab
     Home . Before deleting Excel warns you to restore
     deleted sheet is not possible.

315. For
     renaming a sheet, for example with a name
     Sheet1 , right click
     mouse button on the sheet tab,
     context menu select item — Rename and enter a new name
     over the old one. As a result, there will be
     renaming a sheet. Rename
     the selected sheet can also be commanded Format/Rename sheet.

317. Practical
     reference

318. 1.
     Delete the sheet added in the previous
     assignment.

319. Relocation,
     copy sheet

320. For
     move or copy a sheet
     call the context menu on
     tab of the selected sheet and select
     context menu command
     Move/copy .
     In dialog box Move
     or copy
     must indicate which working
     book moves the selected sheet and
     in front of which sheet it should be located.
     In case of sheet copying,
     checkbox Create
     copy .
     Copy or move selection
     sheet can be done using command Format /
     Move or copy sheet .
     Sheet moving operation is convenient
     produce with the mouse. For this pointer
     the mouse is placed on the sheet tab,
     the left mouse button is pressed and the tab
     dragged to the correct location.

321. Practical
     reference

1. V
   workbook create two sheets: sheet
   «Table» and sheet «Diagram».

2. Leaf
   “Table” move to the beginning of the book.

3. On
   sheet «Table» to present in the form
   tables results of the study level,
   structure and dynamics of general morbidity
   population using Excel capabilities
   for data formatting. Example
   performance of the work is shown in Fig. 3.7

4. Save
   changes.

9 0695

	LEVEL, STRUCTURE AND DYNAMICS OF GENERAL
	morbidity POPULATION.
Grades diseases							2001 year					2000
				people		on 1000		%		on 1000
Infectious diseases					4103		61. 1		6.10%		111.4
Diseases circulatory systems					4023		60		6.00%		133
Diseases respiratory system					19547		291. By alexxlab View Archive → Similar Posts