478 Answered Questions for the topic Microsoft Excel

Microsoft Excel

07/25/19

How to unhide 'Very Hidden' Worksheet?
I was messing around in the sheet settings and somehow managed to make a sheet 'very hidden', but I cannot seem to make it visible again. How can I make it visible?I am using Excel 2010.
Follows • 1
Expert Answers •1
Microsoft Excel

07/25/19

Swap cell contents in Excel?
Is there an easy way to swap the contents of two cells in Microsoft Excel?By easy, I mean either a keyboard shortcut or menu item, without involving copying to temporary cells or writing VBA... more
Follows • 1
Expert Answers •1
Microsoft Excel

07/25/19

After so many years of existence and functionality needs expressed by users, why the library of functions in Microsoft Excel spreadsheets did not grow significantly to simplify recurring routines?
Follows • 1
Expert Answers •1
Microsoft Excel

07/24/19

How can I use Excel to combine people’s first and last names if the data have been split into two columns, one for given name and one for surname?
Follows • 1
Expert Answers •2
Microsoft Excel

07/24/19

How can I select data and draw chart using a button in Excel?
Follows • 1
Expert Answers •1
Microsoft Excel

07/24/19

Can we promote a particular cell value to a formula in Excel?
Follows • 1
Expert Answers •1
Microsoft Excel

07/23/19

Why does Excel in Windows 10 all of a sudden shut all Excel files, then says file is corrupted?
Follows • 1
Expert Answers •1

07/23/19

How do I link an Excel spreadsheet into Access?
I need to incorporate data from an Excel spreadsheet into Access so it can be included in a report. How do I link an Excel spreadsheet into Access?
Follows • 1
Expert Answers •2
Microsoft Excel

07/23/19

Can we convert a data table in picture format to excel format?
Follows • 1
Expert Answers •1
Microsoft Excel

07/22/19

Are there any limitations of pivot table in financial analysis? What are they?
Follows • 1
Expert Answers •1
Microsoft Excel

07/21/19

For ARO recruitment in Allahabad, what is the pattern of computer test in stage 2? Is it just the typing test or skill of PowerPoint, Word, and Excel?
Follows • 1
Expert Answers •1
Microsoft Excel Hyperlink

07/20/19

Can I use an excel formula to extract the link location of a hyperlink in a cell?
I have a spreadsheet with a large number of cells containing hyperlinks with display text different than the hyperlink locationie:*cell location: A1**display text = "Site Info"**hyperlink location... more
Follows • 1
Expert Answers •1
Microsoft Excel

07/20/19

Which loop function should I use to copy a small data and paste it to huge database in a repetitive mode?
Follows • 1
Expert Answers •1
Microsoft Excel

07/20/19

Why sometimes I need to put parenthesis in VBA?
Follows • 1
Expert Answers •1
Microsoft Excel

07/20/19

Can I use visual basic in MS Office for creating and developing simple applications that will function within the MS Office only?
Follows • 1
Expert Answers •1
Microsoft Excel

07/20/19

Why do I need spreadsheets when there are alternatives with better user experience?
Follows • 1
Expert Answers •1
Microsoft Excel

07/20/19

Can we record macro in outlook where I can open excel attachment and format in required sequence?
Follows • 1
Expert Answers •1
Microsoft Excel

07/19/19

Why can't I click on a plot in excel to see which cells it is related to despite it not being protected?
Follows • 1
Expert Answers •1
Microsoft Excel

07/18/19

Can I use conditional formatting in Excel 2010 to highlight cells according to a date found in two other columns?
Follows • 1
Expert Answers •1
Microsoft Excel

07/18/19

Why does adding a new column and updating it in a clustered column store indexed table make queries slower?
Follows • 1
Expert Answers •1
Microsoft Excel

07/17/19

Why do I get compile error when invoking an Excel macro from python on a line that Excel calls another file to run?
Follows • 2
Expert Answers •1

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
Follows • 1
Expert Answers •1
Microsoft Excel Worksheet Function

07/17/19

How to compare two columns and find differences in Excel?
I have two columns in Excel that I want to compare and find the differences between them.Suppose: - Col A has 50 numbers, i.e. 0511234567 - Col B has 100 numbers in the same format
Follows • 4
Expert Answers •3
Microsoft Excel

07/17/19

How can I change my Excel data table so that my 40 columns become 40 rows and my 8 rows become 8 columns? How do I do that to include the headings?
Follows • 1
Expert Answers •1
Microsoft Excel

07/16/19

How can I use the Excel function SUMIF in a table considering the data are vertically displayed and the criteria are not in the same rows as the items that must be summed? There is a 1-row shift.
Follows • 1
Expert Answers •1

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.