Posts tagged with excel:

How to add side by side rows in excel pivot table ?Hello, I am trying to add another row into pivot table, to display them next to each other, but it doesn't work. Could you please give me advice how to do it ?

Excel and Word menu tabs & tools in toolbars disabled / grayed outHello, On my company laptop, when I open a document in Excel or Word, I can't edit the content, because menu tabs and tools in toolbars are grayed out. I can't use...

How to copy and paste date as text format in Excel ? Convert data.How to copy and paste formatted date as text in Excel ? I am trying to convert date to text format by using Ctrl+C and Ctrl+V. After I choose to paste only the values, I get...

Is CSV excel file Comma or Semicolon separated / delimited ?Should be the CSV file values separated by Commas or Semicolons ? What separator has to be used ? Which one is correct ?

Zero value not showing on Excel chart vertical axis - how to display ?I have created an Excel column chart with positive and negative values on axes, but the zero value is not showing on vertical axis. Other numbers on axis are displayed...

How to show Euro, Dollar or Pound sign on right in Excel ?Is it possible to align Euro, Dollar or Pound currency symbol to the right side in Excel ?

Read CSV and Excel files in Visual Studio - CSV viewer / editorWhat should I do to show CSV or Excel file content in cells (columns) in Microsoft Visual Studio ? How can I view CSV file's content in the same way as in Excel ?

Check if value exists in column more than once or twice - ExcelHow can I check if value exists in the range in Excel column more than once, twice or specific fixed number of times ?

Sum or count cells in entire column except the header one - ExcelHi, how can I sum or count cells in entire excel column, except the first one in the header ? How to select entire column, but exclude a certain rows ? How should the formula...

How to convert bulk JSON files into Excel or CSV format easily?I regularly handle multiple JSON files from APIs and software applications, and manually converting them into Excel or CSV takes too much time. Some online tools also fail to...