Explore Excel on Experts Exchange

Expert Solutions for Your Tech Problems

ExcelMicrosoft Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user int...

Read more
  • 144K Content
  • 12K Contributors

Expert Spotlight
Finance Analyst

30 years in Financial Services and Management Accounting. CIMA trained but prefer the technical or system aspects of accounting.

Troubleshooting Question

Modify Excel cell and reformat assistance.

3

I have an excel field with a phone number like this: (605) 333-0071


How do I remove the paraenesis,

Troubleshooting Question

Can Excel display the the number of rows?

3

I see Mansfield has 10 rows, and Oxford has 2 rows.


What Excel formula would calculate and display 10

Troubleshooting Question

Excel: I need to Transform the CSV import to reduce the size of the set

4

The file is a CSV and I imported from a small version of the file, which was 72KB. I imported in

Troubleshooting Question

Import new CSV file data in to an existing Excel workbook with predefined formats

1

I have an Excel Worksheet ( cal_cost.xlsx ) with predefined column headers. Some examples of the

Troubleshooting Question

vba to create a folder based on a path in the open workbook cell

byEuro5
2

I want to use vba to create a folder based on a path saved in the 

Open workbook, 

Troubleshooting Question

SharePoint Issue with Excel sheet with hyperlinks

2

Hello,

 

We have an Excel spreadsheet within a SharePoint folder that for whatever reason the

Troubleshooting Question

Moving rows by value

1

Hello,


I got the following from youtube and added to it to meet my needs (just added a little bit.)

Advice Question

Excel Data Model - Equivalent of vlookup in worksheet table to cross-ref Data Model Table

I have a table in the data model (loaded from a query) with only 2 columns: (1) ID, which is a text

Troubleshooting Question

Highlight Closest Value based on another cell value.

7

I have a number in cell M14 and a table with a range of a3-j3 (this includes headers) that can

Troubleshooting Question

EXcel first in first out 12 month expiration time

byTom M
12

Column a is the month, Column b is the monthly Generation credits and Column c is the month amount

Troubleshooting Question

Converting Cells with Excel formula into Power Query

Hello, 

I'm new to Power Query.  I'm working on a project where I still need to convert formulas I

Troubleshooting Question

macros not digitally signed in excel 2003

3

A customer of mine, running windows 7 with microsoft excel 2003 had me change his hard drive to a

Research Question

Looking for afterhour input excel template

1

Hi experts,

I need help from the IT professionals to check if anyone is using excel file to track

Troubleshooting Question

Create Hyperlink to Excel Sheets on Sheet 1

4

I have created some code with Python that extracts historical stock data. I want the first page to

Advice Question

Programmatically access Microsoft 365 Copilot from an Office Add-In

2

As a C# developer with experience using VSTO to create add-ins for Excel and Word, I'm very

Troubleshooting Question

Is there a way or workaround to auto refresh the excel file without opening it ?

8

Hello,

Is there a way or workaround to auto refresh the excel file without opening it ?


Thank you.

Troubleshooting Question

Excel VBA Code - Copying Image To Wrong Sheet

8

The following Excel VBA code executes when a spreadsheet is opened on a schedule to achieve.an

Troubleshooting Question

Convert Excel to XSD Schema

3

Experts,


I have to load data into a web-based database where I can enter each record manually by

Troubleshooting Question

Office 365 lost recent and pinned files list

1

I have lost my pinned and recent files list in excel and word 365.  see screenshots of another

Troubleshooting Question

Date Picker (Pop Up Calender)

3

Please add solution in attached excel. Thanks!

Question Dt picker.xlsx


How to:


1. add code so that on

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more