0
When creating a pivot table, you are given the option of placing it in a new worksheet or in the current one. So you just need to specify a cell in a blank area of the current worksheet. Then it won't create a new worksheet.
Wiki User
∙ 8y ago
Add your answer:
Earn +20 pts
You used a table to display a range of data in your worksheet While editing the worksheet you decide that although you want to retain the data you no longer want to keep it in table form?
Convert the table into a range
How do you keep website links live in a pivot table?
In a pivot table things will act as headings, so they will lose their links, so what you can do if you want hyperlinks for headings is put some just outside the table and have links on those.
How do you keep the title and column labels of a worksheet on the screen no matter where the worksheet is scrolled?
how do you keep the title and column labels of a worksheet on the screen no matter where the worksheet is scrolled
What is used when you want to keep others from changing the worksheet?
use when you want to keep others from changing the worksheet (password)
What two options do you use with the on commit clause when creating a global temporary table?
KEEP ROWS and PURGE ROWS
Use clothes from castaway in sims 2?
U can make them if you have a creating table with items you collect or you can keep the clothes you already have.
What are advanteges of a worksheet in teaching of physics?
An advantage of using a worksheet in teaching physics is the fact that following a worksheet makes it easier for students to keep up with the lesson. The worksheet is also perfect for studying at home and as a reminder of the lesson.
What is an Equipment Maintenance Worksheet?
An Equiptment Maintenance worksheet is a log to keep track of your equiptment. It is used to show when preventitive maintenance is done and needs done to keep equiptment running smooth
What are the steps for creating a table of content?
Create a heading for the table of contents. List the main sections of your document with corresponding page numbers. Use the "Table of Contents" function in your word processing software to generate automatic links. Update the table of contents as you make changes to your document to keep it accurate.
What is a sentence for pivots?
The basketball player had to pivot with the ball to keep it away from the opponent.
When do you use a pivot foot?
after you have dribbled and have come to a 2- foot- jump stop you are no longer allowed to move. whatever foot you you keep down is your pivot foot.
What part of the tent is the hardest yo keep clean worksheet answer?
The ground floor
