478 Answered Questions for the topic Microsoft Excel

Microsoft Excel

07/16/19

How compatible are Microsoft Excel and Google Sheets files?

Microsoft Excel

07/16/19

How can I add a VB macro into an Excel file using Java?

Microsoft Excel Worksheet Function

07/15/19

What does "A1:A4^{1,2,3}" mean in an Excel formula?

What does the caret operand in Excel do to a range when it is followed by some other numbers in brackets? For example lets say we have the following table: A B C 1 1.5 0 0... more
Microsoft Excel

07/14/19

Why does my excel do not show option of "insert"? Any idea about this problem?

Microsoft Excel Notepad Linebreaks

07/13/19

Why do Excel line breaks not transfer into Notepad?

When copying a cell with line breaks in Excel and pasting it into Notepad, the text is pasted onto one line. Why is that?
Microsoft Excel

07/12/19

Can excel manipulation logic for SQL Server be automated in Uipath?

Microsoft Excel

07/12/19

Why does Excel sometimes select the wrong cell (until I resize the window)?

Microsoft Excel

07/12/19

Can you get data from SQLite into MS Excel?

Microsoft Excel Keyboard Shortcuts

07/12/19

How can I change the focus in Excel to the formula bar via the keyboard?

I like to avoid using my mouse as much as possible, but on occasions when I need to type directly into the formula bar I am currently forced to 'rattle the rodent'. Does anyone know a way to move... more
Microsoft Excel

07/12/19

When does Excel decide to overflow text into adjacent cells, or cut them at the boundary?

In Excel, 2010 or any other version probably, if I enter in a cell, a long single-line text that is longer than the width of the cell, Excel sometimes render the text across the next adjacent... more
Microsoft Excel Microsoft Excel 2010

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
Microsoft Excel

07/12/19

How can I execute a macro in an Excel file while having it open with Java?

Microsoft Excel

07/11/19

Can I automate excel to download the entire NSE or BSE regularly?

Microsoft Excel

07/11/19

Can I set multiple hyperlink color styles in OpenOffice Calc?

Microsoft Excel

07/10/19

How can I apply RANK formula in Excel on mobile?

Microsoft Excel

07/10/19

How can you hide a row on Excel using a formula based on condition?

Microsoft Excel

07/10/19

Which result will I get if VLOOKUP finds more than one match?

Microsoft Excel

07/10/19

How can I tell Excel to divide a number multiple (or 'n') times?

Microsoft Excel

07/10/19

Can we update graphs in MS Excel?

Microsoft Excel

07/09/19

Why use CONCATENATE vs & in Excel?

I noticed that `"EXEC MySproc," & "arg, " & "arg2"` is essentially the same as `=CONCATENATE("EXEC MySproc,", "arg,", "arg2")` including the ability to use evaluations, functions... 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.