Menu
Close
One worksheet can be used to view specific aspects of several different worksheets. This can be done using the Linked Picture option. There are a few options when consolidating information from multiple worksheets, and in this tip, we’ll deal with the most popular. The option for this tip enables you to paste the copied cells […]
Are you looking for a shortcut to quickly rearrange your worksheets in alphabetical order? Instead of dragging and manually arranging your worksheets, you can use VB for Microsoft® Excel® to quickly rearrange them into alphabetical order. Excel currently has no built-in function to rearrange your worksheets. Therefore, if you have a workbook with many worksheets, […]
You have taken time to create a product sales PivotTable and now you would like to analyze the data. You want to analyze the sales per branch by quickly generating PivotTables for each branch to be placed on separate worksheets. In this week’s tip, we take you through a few easy steps as we show you […]
Some businesses use Microsoft® Excel® to prepare and present their business reports. Report headings often contain worksheet names, and to make your reports more efficient, you can link these worksheet names to a specific cell. So, instead of retyping the worksheet names in your report headings, you can easily apply the MID and FIND functions in […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.