Xu Hướng 6/2023 # Group Or Ungroup Shapes, Pictures, Or Other Objects # Top 6 View

Bạn đang xem bài viết Group Or Ungroup Shapes, Pictures, Or Other Objects được cập nhật mới nhất 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.

You can group shapes, pictures, or other objects. Grouping lets you rotate, flip, move, or resize all shapes or objects at the same time as though they were a single shape or object. You can also change the attributes of all of the shapes in a group at one time, and you can ungroup a group of shapes at any time and then regroup them later.

Do one of the following:

Notes:

You can make changes to the entire group, such as adding a shape fill or effect, or an effect to a picture.

You can create groups within groups. For example, add another item on top of an existing item to build complex drawings.

You might want to move a group but leave one shape or picture behind, or make extensive changes to one shape without changing the other shapes in the group.

Select the group that you want to ungroup.

Do one of the following:

Notes:

If you converted a SmartArt graphic to individual shapes, you can’t convert them back to a SmartArt graphic or regroup them.

For all apps except Word

Select any one of the shapes, pictures, or objects that were previously in a group.

Do one of the following:

Here are some reasons why the Group button is grayed out and the things you can do to get it back.

Only one shape or picture is selected. Make sure you have multiple shapes or pictures selected.

Your selection includes a table, worksheet, or GIF image. The Group button will not be available if any of these objects is selected.

If you are using Word, and trying to group pictures, Wrap Text may be set to In line with Text. Change the layout option to anything but In line with Text for every single picture you want to group.

In the above example, the blue square and the green circle can be grouped together. But the shapes cannot be grouped with the placeholder text.

To get the Group button back, move the shape, picture, or object to another location on your slide outside of the placeholder text, or remove the placeholder from the things you want to group.

Press and hold CTRL while you select the shapes, pictures, or objects that you want to group.

Do one of the following:

To ungroup a group of shapes, pictures, or other objects (for example, if you want to move a group but leave one shape behind or make extensive changes to one shape without changing the other shapes), do the following:

Select the group that you want to ungroup.

Do one of the following:

Select any one of the shapes or objects that were previously in a group.

Note: If you converted a SmartArt graphic to individual shapes, it is not possible to convert them back to a SmartArt graphic or to regroup them.

Do one of the following:

If your selection includes a table, worksheet, or GIF image, the Group button will not be available. In PowerPoint, the Group button may not be available if the shape, picture or object has been inserted into a placeholder or you are trying to group a placeholder, as placeholders cannot be grouped with other shapes, pictures, objects.

You can also add a caption to a picture in Office Word 2007 without using a text box. Do the following:

You can now select the caption and change the text and the text formatting.

Drag the group that you want to ungroup onto the drawing canvas.

Do one of the following:

Drag the shapes, pictures, or objects off of the drawing canvas.

Select the drawing canvas and then press DELETE.

If you want to give the shapes of your SmartArt graphic a complex look or get fine control over resizing and positioning of shapes in your SmartArt graphic, convert your SmartArt graphic to individual shapes.

Important: After you convert your SmartArt graphic to individual shapes, it is not possible to convert them back to a SmartArt graphic. When you convert a SmartArt graphic, you cannot automatically layout shapes, and you lose the design and formatting tools available on the SmartArt Tools tabs, including the Layouts, Change Colors, and SmartArt Styles galleries. However, you can still format the shapes by using the options on the Drawing Tools tab instead.

Select all of the shapes in your SmartArt graphic.

Note: When you convert to shapes from a SmartArt graphic, each individual shape becomes a grouped shape. So for every shape in your SmartArt graphic, two shapes are grouped when you paste – one shape is for the text, and the other shape is for the geometry. If the shape in your SmartArt graphic did not contain text, you may see a font or text size that is different from the other shapes when you enter text in the shape.

How To Group Or Ungroup Worksheets In Excel?

How to group or ungroup worksheets in Excel?

If the sheets in a workbook are in the same structure, you can quickly perform tasks on multiple worksheets at the same time by grouping worksheets together. It means that, while you sum a range in a worksheet, the same operation is carried on in the same range of others sheets in the group simultaneously.

Group worksheets

Ungroup worksheets

Group worksheets

To group worksheet will save our time while doing the same calculations in the same range of each sheet.

Press Ctrl key to select the sheet tabs which you want to group if you want to group continuous sheets, hold Shift to select the first and last one tab.

Now while you doing some changes in a sheet, the others change also.

Ungroup worksheets

To Ungroup worksheet, you can use two methods.

Relative Articles

The Best Office Productivity Tools

Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

Reuse:

Quickly insert

complex formulas, charts

and anything that you have used before;

Encrypt Cells

with password;

Create Mailing List

and send emails…

Super Formula Bar

(easily edit multiple lines of text and formula);

Reading Layout

(easily read and edit large numbers of cells);

Paste to Filtered Range

…

Merge Cells/Rows/Columns

without losing Data; Split Cells Content;

Combine Duplicate Rows/Columns

… Prevent Duplicate Cells;

Compare Ranges

…

Select Duplicate or Unique

Rows;

Select Blank Rows

(all cells are empty);

Super Find and Fuzzy Find

in Many Workbooks; Random Select…

Exact Copy

Multiple Cells without changing formula reference;

Auto Create References

to Multiple Sheets;

Insert Bullets

, Check Boxes and more…

Extract Text

, Add Text, Remove by Position,

Remove Space

; Create and Print Paging Subtotals;

Convert Between Cells Content and Comments

…

Super Filter

(save and apply filter schemes to other sheets);

Advanced Sort

by month/week/day, frequency and more;

Special Filter

by bold, italic…

Combine Workbooks and WorkSheets

; Merge Tables based on key columns;

Split Data into Multiple Sheets

;

Batch Convert xls, xlsx and PDF

…

More than 300 powerful features

. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.

Read More… Free Download… Purchase…

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

Enable tabbed editing and reading in Word, Excel, PowerPoint

, Publisher, Access, Visio and Project.

Open and create multiple documents in new tabs of the same window, rather than in new windows.

Increases your productivity by

Read More… Free Download… Purchase…

Cách Group Và Ungroup Dữ Liệu Trong Pivot Table

Trong các trường hợp Pivot Table đưa ra kết quả khá cồng kềnh, các bạn có thể Group data lại thành từng nhóm để phục vụ cho việc quan sát và phân tích dễ dàng hơn. Bài viết sẽ đưa ra 1 số ví dụ cụ thể để giúp các bạn hình dung về việc Group các dữ liệu trong Pivot Table thành các nhóm.

Nhìn vào bảng trên, chúng ta khó nhận thấy xu hướng biến động sản lượng của từng chi nhánh vì các ngày khá rải rác và rời rạc. Để có thể phân tích dễ hơn, chúng ta có thể nhóm các ngày thành nhiều nhóm như: cùng tháng, cùng quý…

Trước hết, chúng ta kích chuột phải vào bảng Pivot, chọn Group để hiện ra cửa sổ Grouping.

Trong cửa sổ Grouping, Excel đã tự động điền các giá trị “Starting at” và “Ending at” (bạn có thể thay đổi ngày theo nhu cầu sử dụng). Tại ô By, các bạn chọn khoảng thời gian của các ngày mà các bạn muốn group, ví dụ chọn Months nếu muốn group theo tháng, chọn Quarters nếu muốn group theo quý, hoặc có thể chọn cả Months và Quarters nếu muốn group vừa theo tháng vừa theo quý..

Sau khi chọn xong các tiêu chí (ở đây mình vừa group theo tháng và theo quý), bấm OK thu được bảng kết quả:

Như vậy chúng ta có thể nhìn thấy rõ hơn sản lượng sản xuất được của chi nhánh A so với chi nhánh B trong từng tháng, từng quý, hoặc giữa các tháng, các quý của từng chi nhánh.

2. Group dữ liệu dạng số:

Ta có bảng Pivot sau là số lượng khách hàng tiêu thụ mặt hàng A theo từng độ tuổi

Chúng ta sẽ thực hiện group tuổi khách hàng thành từng nhóm tuổi như sau:

Kích chuột phải vào vùng Pivot Table, chọn Group để hiện cửa sổ Grouping. Tại cửa sổ grouping, lần lượt điền các giá trị Starting at và Ending at, tại ô By điền số thể hiện khoảng cách giữa số bắt đầu và số kết thúc trong từng nhóm.

Đối với yêu cầu trên, ta chia thành từng nhóm cách nhau 10 tuổi: từ 1 đến 10 tuổi, từ 11 đến 20 tuổi…

Nhấn OK, ta thu được kết quả:

Như vậy nhóm khách hàng từ 21 đến 30 là nhóm tiêu thụ sản phẩm A nhiều nhất.

Lưu ý: Các dữ liệu được sử dụng để Group phải có cùng 1 kiểu dữ liệu.

Để có thể đưa Pivot trở về trạng thái ban đầu, các bạn chỉ cần kích chuột phải và chọn Ungroup để xóa bỏ lệnh Group vửa tạo.

Nguồn: chúng tôi – Sưu tầm

Last modified on Thursday, 07 April 2023

Tables And Other Formatting Controls

In this lesson, we’re going to delve into tables, which are a huge part of laying out well formatted documents. After we discuss tables, we’ll cover some other controls that will help round out your formatting prowess, including adding links, using symbols, creating math equations, and quite a bit more!

By now, you should be very well acquainted with getting your documents up to a level where you can adjust the tabbing and indenting, paragraph alignments, line spacing, and create quick, customized lists. If you need a refresher of what we’ve covered so far, you should check out Lesson 1 and Lesson 2 so you can bring yourself up to speed.

Tables

One of the most common formatting elements you will use in Microsoft Word are tables, so much so that it’s probably a surprise we aren’t covering them until now!

Here you see a grid that allows you to quickly spec out a table but you can also insert, draw, or pick from some predefined “Quick Tables”.

The fast way is to simply trace out the table you want using the provided grid. In the screenshot, you see we trace out a 6 x 5 table, which is previewed in the document.

With your table now placed into your document, you can set out about formatting it, which we’ll cover shortly.

Insert Table

Secondly, you can “Insert Table,” which means you just input the number of columns and rows and how you want the column to “AutoFit.” If you choose fixed column width, you can select “auto” or you can assign a size. Alternatively, you can AutoFit columns to fit the contents, or you can have the content AutoFit to the window.

Finally, if you intend to reproduce the table or you use that size frequently, you can have the “Insert Table” dialog remember those dimensions for new tables.

Draw Table

When you draw a table, the cursor is changed to a pencil and you can “draw” out the column and rows. In this way you can size the table to your liking.

Once you draw your first cell, you can then draw further cells, and create the table that is more based on how you want it to look than necessarily what it requires.

Convert Text to Table

Let’s imagine you have a bunch of text and numbers, and you realize that it would be easier to read if it were in neat columns and rows. Not to fear, text to table will allow you to quickly and easily convert all that data into a table that you can then format to your heart’s content.

So how does this work? Simply, when you want to convert a section of your document to a table, you select the section using your mouse pointer and then select “Convert Text to Table.” The resulting dialog box allows you to choose how many columns you want.

The number of rows will be automatically determined by line breaks, so for example, if you have a block of text divided with flour line breaks, your table will have four rows.

Columns are determined by commas, tabs, paragraph breaks, or another symbol you can manually assign.

Quick Tables

Quick tables are fairly easy to reason out. Let’s say you want to insert a quick calendar, matrix, or a tabular list. You can also create your own table and save it to the list for later, quick use. Simply select the table you want to save, and select “Save Selection to Quick Tables Gallery.”

There’s not a whole lot to master here. Keep in mind, when you insert a quick table, you can then edit and format as you would any table that you created from scratch. And, on that note, let’s actually dive into all that formatting information we’ve been alluding to throughout this lesson.

Formatting Tables

You get a larger variety of tools at your disposal. Note also, you can delete a table easily this way:

Back to the Ribbon, on the far right side of the “Layout” tab, you’ll find some handy controls for controlling your “Alignment” and “Data.”

You can also “Sort” cell data, insert formulas, convert your table to plain text, and repeat header rows. The last option is useful if you have a table that spans multiple pages, you can designate “header rows,” which will persist as you scroll through the table. This is useful for keep track of what column is what in long tables.

The “Design” tab by contrast is all about how your table(s) appear.

At the bottom of this menu, you can modify your table’s style if the current selection of tables doesn’t suit you. When you make changes, they will be previewed so you can see them before you commit.

While formatting or modifying a table, if the built-in selections aren’t close to what you want, you may just want to start from scratch. In this case, you can you the “New Style” dialog, which will be allow you to build a new table style based on current table styles.

There’s little difference to this dialog and the modify dialog except that modifying is based off an existing table design.

In the end, formatting your tables is going to come down to what kind of data you’re presenting and personal preference. We suggest that if you want to fully master tables, you create a blank document and mess around to your heart’s content. We are certain you’ll be creating and formatting eye-catching data-sets in less than it takes to say “columns and rows!”

Note, if you want to learn more about Excel formulas and functions, check out our How-to Geek School series on Excel Formulas and Functions!

Other Formatting Controls

On the right half of the Insert tab are some further formatting controls you should be aware of. Some of these may be of limited daily value to you, but we think it’s important to know about them in case you ever have need for them.

Links

It doesn’t have to be an Internet URL either, it can simply refer to a location on your computer or another location in your document. Mostly though, you will probably want to refer to an Internet location, such as the best place on earth to get your geek fix!

Header, Footer, and Page Number

Headers and footers are useful for repeating the same piece of information at the top and/or bottom of each page, such as if you want to have the title of your book at the top of each page, or similarly, page numbers.

When you choose a style, the header or footer will open and the Ribbon will change to present you with special formatting options.

So you can type in your header or footer, and then decide where you want to position it, whether it’s the same across each page, and so on.

In the same vein, when you add page numbers, you can place it anywhere within a header or footer, picking from a pre-defined list of numbering styles.

If you want to “Format Page Numbers,” you’ll be presented with dialog box, which will allow you to change the number format, add chapter numbers, and dictate from where it starts.

Overall, the header and footer controls are quite easy to grasp and master. So, if you have an instructor who’s a bit old-fashioned and demands you include them in your paper, or you want the title of your book, or your name on every page, or simple page numbers – you should have no problem adding and manipulating them.

Equations

We’re not going to spend a great deal of time explaining the “Equation” functions in Word 2013. We’re guessing the vast majority of people using Word, will never have occasion to insert an equation into their documents.

That said, let’s explain the function exists in the first place. In Word, you can write a simple like “A=πr2” because you can insert the symbol for pi and then use superscript font to show radius squared.

However, if you want to write out anything more complicated than that, you’ll need to insert it using the “Equation” function. You can either select a pre-built equation from the dropdown list:

Note, the Ribbon immediately changes when you insert an equation to the “Equation Tools,” which offers a wide array of math symbols and operators, so you don’t have to try to figure out how to do it on your own.

So, if you’re a bit of a math geek or you’re taking a class and need to write a paper on a mathematical theory, you can present it ϥώwith all the necessary equations to show your work.

Symbols

Symbols are characters that aren’t immediately found on your everyday, run-of-the-mill keyboard. For things like the copyright symbol and British Pounds, you need to insert the symbol using the “Symbols” function on the “Insert” tab.

For example, if you want to write “façade” and using the cedilla (ç), you’d pick it from the “Latin” subset. Similarly, something like café with its acute accent, can be added using the “Symbol” dialog box.

Note that you can also insert foreign letters using shortcut keys. You can see which shortcut key is used for each symbol at the bottom of the “Symbol” dialog box.

Note, that in the above instance, you’re not going to type “CTRL + ‘ + , + E” rather it’s “CTRL + ‘ + E.” The comma is simply there to tell you must first hold down the “CTRL” button, then press the apostrophe and “e” to insert an “é” in your document. Similarly, hold down “CTRL” plus comma and “c” to insert a “ç” and so on.

Coming up Next…

And so ends Lesson 3. We hope you enjoyed it and learned a thing or two. Knowing how to lay out tables in Word will give you a great deal of control over how you present data. Rather than simply having information in sentences or making lists, you can arrange it in neat rows and tables complete with customized colors and borders. The only limit is your creativity!

Moreover, if you’re going for a more published look and feel to your document, adding headers, footer, and page numbers is a great skill to have. Meanwhile, placing links in your documents will help readers navigate and read up on things you might otherwise have to explain with footnotes and such.

Tomorrow, in Lesson 4, we will dive into adding illustrations (such as pictures and shapes) to your documents, allowing you to create eye-popping layouts with tons of variety. You can even embed video for a true multimedia experience. We’ll end with how to add and use multiple languages, so you don’t want to miss out!

Cập nhật thông tin chi tiết về Group Or Ungroup Shapes, Pictures, Or Other Objects 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!