5 Answered Questions for the topic microsoft excel 2010

08/04/19

#### Copy Excel worksheet and maintain relative cell reference in formulas?

Another copy problem in Excel: How can I copy a Worksheet from WorkbookA.xlsx into WorkbookB.xlsx without the copied Worksheet still referencing WorkbookA.xlsx e.g. the formula `=B!23` becomes...
more

08/03/19

#### Prevent Excel from clearing copied data for pasting, after certain operations, without Office clipboard?

Whenever you copy a cell or a range of cells in Excel (my version is 2010 on Windows 7), and then do something else like insert new sheet row or simply edit another cell, Excel removes the...
more

07/30/19

#### Create a pie chart from distinct values in one column by grouping data in Excel?

I have an Excel document containing information from a survey. I want to create a pie chart over location (countries).How can I make Excel group all the distinct values together and then display...
more

07/17/19

#### Unable to get Excel to recognise date in column?

I constantly have problems working with dates in Excel, I must be doing something wrong but I don't understand what.I have a spreadsheet, exported from our exchange server, that contains a column...
more

Microsoft Excel 2010 Microsoft Excel

07/12/19

#### Pasting text into Excel without splitting on spaces (or other delimiter)?

I recently used the Text to Columns feature in Excel to split a column of data into multiple columns based on the space character. Now when I paste text into Excel it automatically splits it into...
more

## Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.

Most questions answered within 4 hours.

#### OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.