Logo
programming4us
programming4us
programming4us
programming4us
Home
programming4us
XP
programming4us
Windows Vista
programming4us
Windows 7
programming4us
Windows Azure
programming4us
Windows Server
programming4us
Windows Phone
 
programming4us
Windows 7

Microsoft Excel 2010 : Removing Table Rows and Columns & Entering Data in a Table Using a Drop-Down List

- How To Install Windows Server 2012 On VirtualBox
- How To Bypass Torrent Connection Blocking By Your ISP
- How To Install Actual Facebook App On Kindle Fire
8/22/2011 9:24:54 AM

Removing Table Rows and Columns

If you no longer need a row or column in a table, you can quickly remove it using Delete commands on the Home tab. You delete rows and columns in a table the same way you delete rows and columns in a worksheet. As you enter data in a table, sometimes you accidentally enter the same data more than once. Instead of searching for duplicates manually, Excel can search for duplicates and then remove them for you.

Delete Rows or Columns from a Table

Click a cell in the table where you want to delete a row or column.

Click the Home tab.

Click the Delete button arrow, and then click Delete Table Rows or Delete Table Columns.

Remove Duplicate Rows from a Table

Click a cell in the table.

Click the Design tab under Table Tools.

Click the Remove Duplicates button.

Select the columns with duplicates you want to remove. You can click Select All or Unselect All.

Click OK.

Click OK to remove duplicates.


Entering Data in a Table Using a Drop-Down List

Entering data in a list can be tedious and repetitive. You can enter data using the PickList or List AutoFill feature to make the job easier. PickList is activated once you have entered at least one record in the list; it uses your previous entries to save you the trouble of typing repetitive information. PickList displays previous entries made in the current field in a list format. List AutoFill automatically extends the list’s formatting and formulas to adjacent cells. As data is added to a list, AutoFill looks at the preceding cells to determine what formatting and formulas should be extended.

Enter Data in a List Using Pick From Drop-Down List

Right-click the cell in which you want to use PickList, and then click Pick From Drop-Down List.


Click a selection in the list.

Press Enter or Tab to accept the entry, or press Esc to cancel the entry.
Other -----------------
- Microsoft Excel 2010 : Creating Calculations in a Table & Working with Tables
- Microsoft Word 2010 : Using Content Controls to Create Documents
- Microsoft Word 2010 : Saving a Document with Macros & Opening a Document with Macros
- Visual Basic 2010 : Advanced Compilations with MSBuild - Introducing MSBuild (part 2) - Understanding Tasks and Creating Targets
- Visual Basic 2010 : Advanced Compilations with MSBuild - Introducing MSBuild (part 1) - Introducing Projects
- Microsoft Visio 2010 : Enhancing Diagrams by Adding Hyperlinks & Using Hyperlinks
- Microsoft Visio 2010 : Modifying an Existing Report
- Microsoft PowerPoint 2010 : Avoiding Harmful Attacks & Using the Trust Center
- Microsoft PowerPoint 2010 : Sending a Presentation for Review Using E-Mail & Sending a Presentation by Internet Fax
- Troubleshooting Performance Problems (part 3) - Troubleshooting Disk Performance Problems & Configuring Power Settings
 
 
Top 10
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Finding containers and lists in Visio (part 2) - Wireframes,Legends
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Finding containers and lists in Visio (part 1) - Swimlanes
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Formatting and sizing lists
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Adding shapes to lists
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Sizing containers
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 3) - The Other Properties of a Control
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 2) - The Data Properties of a Control
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 1) - The Format Properties of a Control
- Microsoft Access 2010 : Form Properties and Why Should You Use Them - Working with the Properties Window
- Microsoft Visio 2013 : Using the Organization Chart Wizard with new data
- First look: Apple Watch

- 3 Tips for Maintaining Your Cell Phone Battery (part 1)

- 3 Tips for Maintaining Your Cell Phone Battery (part 2)
programming4us programming4us
Popular tags
Microsoft Access Microsoft Excel Microsoft OneNote Microsoft PowerPoint Microsoft Project Microsoft Visio Microsoft Word Active Directory Biztalk Exchange Server Microsoft LynC Server Microsoft Dynamic Sharepoint Sql Server Windows Server 2008 Windows Server 2012 Windows 7 Windows 8 windows Phone 7 windows Phone 8
programming4us programming4us
 
programming4us
Natural Miscarriage
programming4us
Windows Vista
programming4us
Windows 7
programming4us
Windows Azure
programming4us
Windows Server
programming4us
Game Trailer