Explore Office on Experts Exchange

Expert Solutions for Your Tech Problems

OfficeMicrosoft Office

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a nu...

Read more
  • 79K Content
  • 14K 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 Solution

index match formula excel

1

Hi, i need some match index formula for a sheet im working on, i need to map the mapped name column

Troubleshooting Solution

how to extract the email names from the distribution list from the Outlook address book in Excel spreadsheet as a column

2

how to extract the email names from the distribution list from the Outlook address book in Excel

Troubleshooting Solution

How do I Save, Edit and Send a Word Document on my iPhone

13

I see how to Save the file. I have saved it to Documents.


How do I open that file so I can change its

Troubleshooting Solution

If statement using dates.

byTom M
2

Book2.xlsxPlease see cell n2, I am not sure what is wrong with this I think it has to do with the

Troubleshooting Solution

Count Unique Excel Values by Using the SUM and COUNTIF Functions

1

Hello, 

my existing formula needs to be modified. It works as long as I don't apply filters on my

Troubleshooting Solution

Hours and minute formula between two cells

byTom M
1

Hours and minute formula between two cells, I need to get a formula that will give me the hours and

Troubleshooting Solution

Need an Excel formula (not array) to return a value if a word in one cell matches another.

8

Book1.xlsx


I have a list of words in Cells B1:B5. I want to return the value "Yes" if any of these

Troubleshooting Solution

Error with linked Excel file on date field.

bybfuchs
13

Hi Experts,

Why do I get in one pc an error when linking to an excel file and field defined as

Troubleshooting Solution

Change font size of one part of an excel cell

byJose C
2

i have the following formula in a column in excel


=row()&" D1 RI "&TEXT(COUNTA(A$2:A2)+1,"00000")


how

Troubleshooting Solution

Macro code problem

9

Hi,

It is having the error

to the line like

Worksheets(List1).Cells(RowID2, 8).Value = Format(Now -

Troubleshooting Solution

Convert entire column to number

bybfuchs
16

Hi Experts,

How do I convert the entire column to numbers, when trying to drag down the right corner,

Troubleshooting Solution

SharePoint 2019  - Replacing Lists with Imports

byJake S
1

I have a form in SharePoint 2019 (local server)  that does a lookup from a list called "Assignment"

Troubleshooting Solution

How do I rotate the direction of a PDF document?

5

I have a front and a back of a PDF with legal-sized document, but it has both sides stacked

Troubleshooting Solution

New Office 2016 Outlook Hate New Layout

7

Hi Experts,


My Office 2016 Outlook just updated and I hate the new layout.  See below.

In particular

Troubleshooting Solution

Steps to add a paid professional Copilot product licensed through my Microsoft Action Pack subscription to Office 365

byIT Guy
1

I understand that the following paid professional Copilot versions are available:


I have a Microsoft

Troubleshooting Solution

Format column as a link

bybfuchs
9

Hi Experts,

How do I set a column in Excel containing URL's to act as a link?

See below, this is just

Troubleshooting Solution

Move old excel data to another sheet

12

Hello,  

I was hoping someone can help me with the code for a macro to do the below:


I have an excel

Troubleshooting Solution

Any free ways of adding Microsoft Copilot through other subscription or package such as Microsoft Action Pack?

byIT Guy
7

Are there any free ways of adding Microsoft Copilot through other subscription or packages such as

Troubleshooting Solution

Adding a picture from Excel using HTML

I need to insert an image in HTML code that I already created for Excel to send a message to all

Troubleshooting Solution

Line Spacing in Excel 365

2

Hi Experts,


I need to whip up a quick sheet in Excel, and suddenly tthe line spacing on the address

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more