Xu Hướng 12/2023 # Table Tool Enhancements In Word 2013 # Top 12 Xem Nhiều

Bạn đang xem bài viết Table Tool Enhancements In Word 2013 được cập nhật mới nhất tháng 12 năm 2023 trên website Hoisinhvienqnam.edu.vn. Hy vọng những thông tin mà chúng tôi đã chia sẻ là hữu ích với bạn. Nếu nội dung hay, ý nghĩa bạn hãy chia sẻ với bạn bè của mình và luôn theo dõi, ủng hộ chúng tôi để cập nhật những thông tin mới nhất.

All versions of Word have given users the ability to arrange text into a Table format – an ideal way to present information in the form of a list with defined Rows, Columns and Cells. However, making structural changes to a Table, like adding additional Rows and Columns to an existing Table, has always meant making sure that your cursor was in the proper Row or Column and then taking a trip with your mouse to the top of the screen to use the various Insert Row and Column tools provided on the Table Tools Layout tab as pictured below:

Now, these tools were not difficult to use, but they were out of the way when you were working in a Table and you had to keep moving your mouse to the top of the screen. Also, if you were not aware of what Row or Column your cursor was in at the time you used one of the buttons, you’d end up with the new Row or Column in the wrong position in your Table.

This makes it faster and more intuitive to add the new Rows and Columns you need without having to move your mouse out of the Table and up to the Ribbons.

The other Table tools that have been enhanced are the tools that let you enhance the thickness, color or style of borders in your Tables. In past versions of Word, you’d first have to select the Rows, Columns or Cells whose borders you wished to enhance and then use the drop down menu from the Borders button and make the correct choice of which Border (top, bottom, outside, inside, etc.) you wished to enhance. This menu was easy to misinterpret and you’d end up with an incorrect border choice that you’d have to undo and try again:

Or, you could have used this menu to open the Borders & Shading dialog box, which was also a non-intuitive and time consuming box to work with:

First, the Border Painter. In order to use this tool, you must first be in an existing Table so the Table tools contextual tabs are present. Then on the Table Tools Design tab, select the style, color and weight (thickness) of your desired Border Style. This automatically turns on the Border Painter as pictured below:

Your mouse pointer will now look like a pen, and you simply drag your mouse over the borders you wish to enhance and they will acquire the border style you want as pictured below:

You will then see a palette of existing Border Styles as well as Recently Used Custom Border Styles. All you need to do is select the Border Style you wish to reproduce. Your mouse pointer will then look like a pen, and you can copy the selected Border Style over any additional Border segments you wish to enhance.

For more Microsoft Applications Training information visit chúng tôi or call 1-855-575-8900.

How To Hide Table Styles On The Table Tools Design Tab In Word (For Developers)

How to hide table styles on the Table Tools Design tab in Word (for developers) The problem: does anyone need 99 ways to format a table?

The Design tab includes the Table Styles group. This gives you, out of the box, 99 table styles from which to choose.

Having applied one of the 99 styles, the user can then choose whether or not to show banded columns, banded rows, header or total rows and so on.

In a corporate environment, the communications people would tear their hair out if users formatted tables in 99 different ways. A corporate environment is likely to have 2 or 3 ‘approved’ ways to format a table.

The solution: hide most, if not all, of the built-in table styles

Well-constructed templates for corporate use are likely to have 2 or 3 custom table styles that fit the corporate branding. Or, the in-house rules may be that 2 or 3 of the built-in styles are to be used, but the rest are off limits.

There is no way in the user interface to hide the built-in table styles.

But you can do it in code. Something like this will do the trick:

Sub HideATableStyle() With ActiveDocument.Styles(Word.wdStyleTableLightShading) .Visibility = True ' Yes, True. .UnhideWhenUsed = False End With End Sub

If you’re creating a template for corporate use, it may be appropriate to hide most of the built-in table styles in the template. Leave the approved custom or built-in table styles visible. Users can then easily apply the corporate-approved table styles when working on documents based on that template.

Sub HideATableStyleButMakeItVisibleWhenUsed() With ActiveDocument.Styles(Word.wdStyleTableLightShading) .Visibility = True ' Yes, True. .UnhideWhenUsed = True End With End Sub

Microsoft Office: 9 Pivottable Enhancements In Excel 2023

By J. Carlton Collins, CPA

Q. What new PivotTable features, if any, have been added to Excel 2023?

A. Microsoft has made several improvements to Excel 2023’s PivotTables. Among them are:

1. Automatic relationship detection: In Excel 2013, pivoting two or more sets of data was a more difficult operation because you had to use Excel’s Relationship tool to define the connecting field names between the separate database tables – a process often referred to as ­ joining the databases. However, Excel 2023 makes this process a little easier with an Auto-Detect ­button that can compare multiple database tables to identify common field names, and then establish the join(s) automatically.

Note 1: For the Auto-Detect tool to work, each database table must first be converted to an Excel Table, using Excel’s Insert, Table, Create Table menu option.

Note 2: The Auto-Detect joining process works only when common field names are used across the various database tables; if the field names do not match exactly (they don’t have to have the same case to match exactly), the join needs to be created manually. For example, the two database tables shown in below each contain a column of invoice numbers, but because the column headings (field names) are different in each table ( Invoice_Number versus Invoice#), the new Auto-Detect feature will not create the join.

Because the field names are not identical in this example, you would need to use Excel’s Create Relationship tool (available from the PivotTable menu) to join the separate database tables together, as pictured in the example below.

This action will launch the Measure dialog box where new measure formulas can be created using the DAX formula programming language. (DAX is an abbreviation for Data Analysis Expressions, which is the native formula and query language included in Microsoft PivotTables, PowerPivot, Power BI Desktop, and SQL Server Analysis Services (SSAS) Tabular models. DAX provides new functions designed to work with relational data, such as the CUBE function.) The detailed explanation of the DAX formulas is beyond the scope of this column, but a simple example of a DAX formula, which calculates a sales-to-cost ratio by product category, might appear as shown below.

(The Measure feature was originally included in Excel 2010 but was removed from Excel 2013. Now this feature has returned.)

3. Automatic date and time grouping: Excel 2023 automatically groups your date- and time-related fields (year, quarter, month) in your PivotTable. Once the fields are grouped together, you can drag the group to your PivotTable in one action to distribute your data across the different levels of time with drilldown capabilities. (In earlier editions of Excel, PivotTables data were plotted by individual dates, and users had to specify date group settings manually using the Group tool.)

4. PivotChart drilldown buttons: Excel 2023 allows you to zoom in and out of your Pivot­Charts across groupings of time and other hierarchical structures within your data.

5. Search your PivotTable: A new Search field (pictured below) in the PivotTable Fields box helps you search and find specific fields across your entire data set. (This feature was included in Excel 2010, was removed from Excel 2013, and is now back.)

6. Smart rename: Excel 2023 enables you to rename tables and columns in your workbook’s data model. With each edit or change, Excel 2023 now automatically updates any related tables and calculations across your workbook, including all worksheets.

7. Defer Layout Update: Similar to setting Excel’s Workbook Calculation option to Manual (by selecting File, Options, Formula) to prevent your workbook from recalculating after each edit, a new PivotTable feature called Defer Layout Update (see the screenshot below) allows you to delay updating your PivotTable calculations while you make multiple changes to your Pivot data. Once you have completed the edits, your changes can be updated throughout the workbook by pressing the Update button, unchecking the Defer Layout Update option, or closing the PivotTable or PowerPivot window.

8. Multi-Select slicer: Excel 2023allows you to ­select multiple items in an Excel slicer on a touch device, as pictured below. (Previously only one item in a slicer could be selected at a time using touch input.)

9. Get & Transform: Excel 2023 provides a new Get & Transform tool (pictured below), which is an improvement over Excel’s previous Get Data tool. This tool helps you connect to data sources, and gather and import the resulting data.

As part of the data import process, the Navigator tool (pictured below) helps you clean your data before completing the data import process. For example, this tool can help you remove columns, change data types, or merge tables.

Once you’ve created your query, you can save it and, if desired, edit it using the Query Editor tool pictured below. This tool allows you to repeat the same data queries without re-creating them from scratch.

This new tool uses technology from the Excel 2010 add-in called Power BI Desktop and enables you to sort, filter, and manipulate large volumes of data much faster than a regular Excel workbook. The functionality between the Power BI Desktop and an Excel worksheet has also been enhanced to allow users to copy and paste queries between the two platforms. In addition, administrators can now set user permissions (or credentials) at the server level, so authorized end users can access the source data more efficiently, without getting bogged down in user access permissions.

About the author

( J. Carlton [email protected]) is a technology consultant, a conference presenter, and a JofA contributing editor.

Submit a question

Do you have technology questions for this column? Or, after reading an answer, do you have a better solution? Send them to [email protected]. We regret being unable to individually answer all submitted questions.

How To Insert A Table In Microsoft Word 2013

Insert a Small Table in Word

To insert the table:

Select the Insert tab.

Move your mouse over the desired number of columns and rows.

Your table is inserted into your Word document with evenly spaces columns and rows.

Insert a Larger Table

You aren’t limited to inserting a 10 X 8 table. You can easily insert a larger table into your document.

To insert a large table:

Select the Insert tab.

Select Insert Table from the drop-down menu.

Select the number of columns to insert in the Columns field.

Select the number of rows to insert in the Rows field.

Select the Autofit to Window radio button.

These steps will insert a table with the desired columns and rows and automatically resize the table to fit your document.

Draw Your Own Table Using Your Mouse

Microsoft Word lets you draw your own table using your mouse or by tapping your screen.

Select the Insert tab.

Select Draw Table from the drop-down menu.

4. Draw a rectangle the size of the table you want to make the table’s borders. Then draw lines for columns and rows inside the rectangle.

Insert a Table Using Your Keyboard

Here is a trick that not many people know about! You can insert a table into your Word document using your keyboard.

To insert a table using your keyboard:

Press the + on your keyboard.

Press Tab or use your Spacebar to move the insertion point to where you want the column to end.

Press the + on your keyboard. This will create 1 column.

Repeat steps 2 through 4 to create additional columns.

Press Enter on your keyboard.

This creates a quick table with one row. To add more rows, simply press your Tab key when you are in the last cell of the column.

Give It a Try

Now that you have seen the easiest ways to insert a table, give one of these methods a try in your documents. You can insert a small, easy table or go for a larger, more complex table. Word also gives you the flexibility to draw your own table, and they even snuck in a keyboard shortcut for you to use!

Thanks for letting us know!

Other Not enough details Hard to understand

Where Is The Tools Menu In Microsoft Word 2007, 2010, 2013, 2023, 2023 And 365

The key feature of new ribbon interface in Word 2007, 2010, 2013, 2023, 2023 and 365 is that all the menus and toolbars of Word 2003, 2002, and 2000 have been categorized and organized in multiple tabs. In other words, because the items have been grouped under different tabs, the tools menu does not exist any longer.

If you try to find any items of the old tools menu in Word 2007, 2010, 2013, 2023, 2023 and 365, please see the following solutions.

Solutions

Solution A: Restore the tools menu. If you are accustomed to the old style menus and toolbars of Office 2003, XP(2002) and 2000, the Classic Menu for Office is perfect for you. It brings back the old menus and toolbars to Word 2007, 2010, 2013, 2023, 2023 and 365. All new features of 2007/2010/2013/2023/2023 have been added into it. Know more…

Solution B: Locate every item (of tools menu) one by one on the new ribbon interface. If you like the new ribbon interface of Word 2007, 2010 or 2013, and want to locate certain functions on the ribbon, please browse the following tables ( Location in Word 2007 and Location in Word 2010/2013). They indicate the new location of different items from the tools menu.

A: Tools Menu

B1: Location in Word 2007

B2: Location in Word 2010/2013

More Tips What is Classic Menu for Office

The software Classic Menu for Office is designed for the people who are accustomed to the old interface of Microsoft Office 2003, XP (2002) and 2000. It brings back the classic menus and toolbars to Microsoft Office (includes Word) 2007, 2010, 2013, 2023, 2023 and 365. The classic view helps the people to smoothly upgrade to the latest version of Office, and work with Office 2007/2010/2013/2023 as if it were Office 2003.

All new features and commands of Office 2007, 2010, 2013, 2023, 2023 and 365 have been added to the menus and toolbars;

Without any training or tutorials after upgrading, users can work with Office 2007/2010/2013/2023 immediately;

Easy to show or hide the classic menus, toolbars and ribbon tabs;

Easy to install and use. Supports all languages. Free download!

Easy to deploy to all computers in your company.

Screen Shot of Classic Menu for Word

Word 2013 & 2023 – Table ‘Repeat Header Row’ Not Working

Formatting documents in Word can be extremely frustrating.

Often Word completely disregards the ‘repeat header row’ setting – leaving you with a table that just doesn’t behave.

Sometimes, no matter what options are selected the ‘Repeat as header row at top of each page’ option doesn’t work as expected, if at all.

The solution is simple, and quite baffling why it works where the other option does not.

Select the table,

at the top of the Window, under under ‘TABLE TOOLS’ open the ‘LAYOUT’ tab,

For whatever reason, where the normal option fails to work this button some how fixes the table and makes the header row repeat across pages.

Help! What if this didn’t work!

Here’s a few tips if the above didn’t help.

Method 1: Text wrapping must be set to ‘None’

Repeatable headers DO NOT work with text wrapping enabled.

On the ‘Table’ tab set ‘Text Wrapping’ to ‘None’

Method 2: Page breaks must NOT be in table

If a page break is inside the table repeatable headers will not work.

To check for page breaks:

Enable the display formatting option on the ‘Home’ tab, under ‘Paragraph’

Look through the table for a page break and delete it, if there is one it will be at the bottom of the page (hence being a page break). You may also need to delete an empty line to join your table together again.

If you need the table to page break you will instead have to enable ‘Page break before’ on the table row. 

Method 3: Nested tables

Repeatable header rows will not work for nested tables, that is, a table inside a table – make sure you only have one table.

Method 4: Turn it off and on again!

Open the table properties

Disable ‘Repeat as header row at top of each page’

Save and close the file

Open the file again

Enable ‘Repeat as header row at top of each page’

References:

Cập nhật thông tin chi tiết về Table Tool Enhancements In Word 2013 trên website Hoisinhvienqnam.edu.vn. Hy vọng nội dung bài viết sẽ đáp ứng được nhu cầu của bạn, chúng tôi sẽ thường xuyên cập nhật mới nội dung để bạn nhận được thông tin nhanh chóng và chính xác nhất. Chúc bạn một ngày tốt lành!