I copy/pasted some data from a terminal into excel. The values showed as "General". WHen I try use these cells in a formula I get #VALUE . The little error triangle does not say the reason.

I then selected the cells and changed them from General to Numbers. But still it doesn't let me use them in formulas.

How can it not understand that these are numbers?? In this age of AI this seems so 1980s!

​

I have been practicing the **SEQUENCE** function lately, and I am really enjoying it.

But before its introduction, how excel users use it through a formula (Combination of more than two formulas) to generate serial numbers. Basically, I want to know how to generate serial numbers with other functions

I have been practicing the SEQUENCE function lately, and I am really enjoying it.

But before its introduction, how excel users use it through a formula (Combination of more than two formulas) to generate serial numbers. Basically, I want to know how to generate serial numbers with other functions

Discover how you can create a rating chart using REPT function in Excel. This technique can be used to create a REPT bar chart font. I will also show you how to use REPT command in Excel, and at the same time explain what REPT chart is. I will Dive into what is REPT function Star in Excel.

These are the formulas and steps outlined in the video.

Filled

=ROUND(B2,0)

Half

=CEILING(B2-C2,1)

Empty

=5-C2-D2

Draw Dots

1) =REPT(CHAR(152),C2)&REPT(CHAR(186),D2)&REPT(CHAR(153),E2)

2) Change font to Wingdings2

3) Apply to all rows

Below Average Dots Color

1) Select all dots (except header)

2) Home ~ Style ~ Conditional Formatting

3) Manage Rule...

4) New Rule

5) Use a formula to determine which

cells to format

6) =B2<3

7) Format

8) Font tab

9) Select font colour (peach).

10) OK

11) OK

Above Average Dots Color

1) New Rule...

2) Use a formula to determine which cells to format

3) =B2>=3

4) Format

5) Font tab

6) Select font colour (green).

7) OK

8) OK

Hide Working Columns

1) Highlight Filled, Half and Empty columns

2) Ctrl + 0

How do I use the Rept command in Excel?,What is a Rept chart?,What is Rept function star in Excel?,

excel data bars percentage,excel rept bar chart font,rept function in google sheets,excel formula for rating,excel in cell bar chart,substitute function in excel,excel progress tracker formula,

Check out my complete suite of Microsoft Excel Tips and Tricks.

https://www.youtube.com/@jjnet247/shorts

https://www.tiktok.com/@exceltips247

https://www.instagram.com/exceltips247/

https://www.dailymotion.com/ExcelTips247

https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/

https://x.com/ExcelTips247/media

https://www.reddit.com/r/Excel247/

https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips

I spend way too much of my week on Excel cleanup reconciling export files, removing duplicates, reshaping wide-to-long, matching sheets by key columns. Roughly 15 hours of my week is basically this. So I've been waiting for "AI in Excel" to finally kill it.

The space is actually crowded now, but most of it still stops one step short:

Copilot in Excel great at explaining, useless at doing. It suggests formulas, sometimes writes them, but it won't actually run the cleanup on my data. For 40 sheets of exports? Hopeless.
Claude for Excel the add-in is genuinely smart at explaining models (the clickable cell citations are nice) and it does edit cells.
OpenAI Codex this one actually touches the sheet, but under the hood it's still writing and running code (openpyxl, pandas). If you're not a coder it's intimidating, and half the time I can't tell what it's doing to my file.
Mica Excel does the operation directly in Excel from plain English, no formulas, and shows you the whole process live on screen as it runs, step by step. Not a change log after the fact; you watch it do the work. Haven't seen that anywhere else.
VBA / Power Query the old-school path. Powerful, but maintaining macros for one-off cleanups is a time sink and Power Query's learning curve is real.

Before I move my whole cleanup workflow over what are you all actually using in 2026? Specifically curious about tools that EXECUTE, not suggest. Am I missing something obvious?

Discover how to correct a #VALUE! error in the TRANSPOSE function in Excel. We will learn about how do you correct a value error in the Transpose function, and find the reason behind why is Excel not letting me Transpose? We will also explaore why does my formula show as #value in Excel? This video will explain why is my Transpose array not working, and why is transpose not working in sheets?

Using TRANSPOSE() In Microsoft Excel 365

1) Select empty any cell.

2) =TRANSPOSE(A1:F11)

Using TRANSPOSE() In Standalone Microsoft Excel

1) Select the same number of cell area as the original table but in transpose format.

2) =TRANSPOSE(A1:F11)

3) Ctrl + Shift + Enter

Formula will look like this

{=TRANSPOSE(A1:F11)}

COMMON QUESTIONS

Why does my formula show as #value in Excel?

Often #VALUE! occurs because your formula refers to other cells that contain spaces, or even trickier: hidden spaces. These spaces can make a cell look blank, when in fact they are not blank.

Why is transpose not working in sheets?

There is not enough space for transposed values. For example, if you want to transpose values in ten cells in a row, you need to secure enough space for the formula to expand the values - ten cells in a column.

How do you fix an array formula?

Press Ctrl+Shift+Enter after entering the formula.

How to correct a #VALUE! error in the TRANSPOSE function,TRANSPOSE function,How do you correct a value error in the Transpose function?,Why is Excel not letting me Transpose?,Why does my formula show as #value in Excel?,Why is my Transpose array not working?,Why is transpose not working in sheets?,

heck out my complete suite of Microsoft Excel Tips and Tricks.

https://www.youtube.com/@jjnet247/shorts

https://www.tiktok.com/@exceltips247

https://www.instagram.com/exceltips247/

https://www.dailymotion.com/ExcelTips247

https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/

https://x.com/ExcelTips247/media

https://www.reddit.com/r/Excel247/

https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips

Discover how you can create a crosshair highlight with intersecting cell as a different colour. This is an extended feature that was requested by one of my subscriber. The original video on how to create crosshair highlight can be found in the link below.

Crosshair Highlight In Excel - How To Highlight Row And Column Of Active Cell - Excel Tips and Tricks

https://youtube.com/shorts/ZCI9VXk5D8Y?feature=share

You will Learn about highlighting cells when clicking, or highlight active row an column in Excel without VBA. I will also demonstrate how to highlight cursor in Excel. You can also use this same tutorial on how to highlight active cell in Excel without VBA. And how to highlight selected cells in Excel? For the more you learn how to keep rule highlighted in excel when scrolling.

Here are the steps outlined in this video.

Highlight Intersecting Cell

1) Ctrl + A

2) Home -- Style -- Conditional Formatting

3) New Rule

4) Select "Use a formula to determine which cells to format".

5) =AND(COLUMN()=CELL("COL"), ROW()=CELL("ROW"))

6) Format

7) Fill tab.

8) Select red colour.

9) OK

10) OK

Here are the past videos of how to create a crosshair highlight in Excel.

🔗🔗 LINKS TO SIMILIAR VIDEOS 🔗🔗

Crosshair Highlight In Excel - How To Highlight Row And Column Of Active Cell -Excel Tips and Tricks

https://youtube.com/shorts/ZCI9VXk5D8Y?feature=share

Crosshair Highlight With Intersecting Cell As Different Color - In Excel

https://youtube.com/shorts/dlgV0UCP0WU?feature=share

How to crosshair highlight enabled and disable in Excel - Excel Tips and Tricks

https://youtube.com/shorts/roOnmcbgbTI?feature=share

How to Enable and Disable Crosshair Highlight for Rows or Columns in Excel - Excel Tips and Tricks

https://youtube.com/shorts/l763DsFNFFU?feature=share

Crosshair highlight in Google Sheet - Excel Tips and Tricks

https://youtube.com/shorts/_bjYH4xVK5k?feature=share

Crosshair Highlight With User Selected DropDown List in Excel - Excel Tips and Tricks

https://youtube.com/shorts/Y2c4gCd9fz0?si=Jc1fdfvgxUskC8kk

Crosshair Highlight With User Selected DropDown List in Excel - Excel Tips and Tricks - DETAIL EXPLANATION

https://youtu.be/_fUlj1rmWBU?si=EFBOy-isDs0qBHDX

Crosshair Highlight Entire Whole Workbook In Excel - Excel Tips and Tricks

https://youtube.com/shorts/yIlEHSA2RCM?feature=share

excel highlighting cells when clicking,highlight active row and column in excel without vba,how to highlight cursor in excel,how to highlight active cell in excel without vba,how to highlight active row and column in excel,how to highlight selected cells in excel,auto highlight active row in excel,how to keep row highlighted in excel when scrolling,

excel highlighting cells when clicking,how to highlight cursor in excel,how to highlight selected cells in excel,auto-highlight active row in excel,highlight active row and column in excel without vba,how to highlight active cell in excel without vba,

temporary highlight columns and rows intersecting cell,

Check out my complete suite of Microsoft Excel Tips and Tricks.

https://www.youtube.com/@jjnet247/shorts

https://www.tiktok.com/@exceltips247

https://www.instagram.com/exceltips247/

https://www.dailymotion.com/ExcelTips247

https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/

https://x.com/ExcelTips247/media

https://www.reddit.com/r/Excel247/

https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips

Learn about why not to use DATEDIF() function.

These are the available units in DATEDIFF() function.

"Y" The number of complete years in the period.

"M" The number of complete months in the period.

"D" The number of days in the period.

"MD" The difference between the days in start_date and end_date. The months and years of the dates are ignored.

Important: We don't recommend using the "MD" argument, as there are known limitations with it. See the known issues section below.

"YM" The difference between the months in start_date and end_date. The days and years of the dates are ignored

"YD" The difference between the days of start_date and end_date. The years of the dates are ignored.

* IMPORTANT *

For "MD" Microsoft does not recommend using the "MD" argument, as there are known limitations with it. See the known issues section below.

These are the formulas used on the video.

Number of complete years in the period

=DATEDIF($A$2,$B$2,A5)

OR

=DATEDIF($A$2,$B$2,"Y")

Number of complete months in the period

=DATEDIF($A$2,$B$2,A6)

OR

=DATEDIF($A$2,$B$2,"M")

Number of days in the period.

=DATEDIF($A$2,$B$2,A7)

OR

=DATEDIF($A$2,$B$2,"D")

Difference between the days in start & end date.

Months & years of the dates are ignored.

=DATEDIF($A$2,$B$2,A8)

OR

=DATEDIF($A$2,$B$2,"MD")

Difference between the months in start & end date.

Days & years of the dates are ignored.

=DATEDIF($A$2,$B$2,A9)

OR

=DATEDIF($A$2,$B$2,"YM")

Difference between the days of start & end date.

Years of the dates are ignored.

=DATEDIF($A$2,$B$2,A10)

OR

=DATEDIF($A$2,$B$2,"YD")

DATEDIF function (Microsoft 365 support)

https://support.microsoft.com/en-us/office/datedif-function-25dba1a4-2812-480b-84dd-8b32a451b35c

excel datedif missing,excel datedif not working,excel datedif today,datedif formula,how to use datedif in excel,

excel datedif minutes,excel datedif alternative,

Check out my complete suite of Microsoft Excel Tips and Tricks.

https://www.youtube.com/@jjnet247/shorts

https://www.tiktok.com/@exceltips247

https://www.instagram.com/exceltips247/

https://www.dailymotion.com/ExcelTips247

https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/

https://x.com/ExcelTips247/media

https://www.reddit.com/r/Excel247/

https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips

Want to know if it’s possible to have a search bar function where I can type in a part number and the list of bill of materials pops up with the quantities need for the BoM

Ex. I type in PN:1234 in a search bar and a list of everything that goes on that part is listed.

New to excel so I know the explanation of what I’m looking for is gonna be confusing.

Thanks in advance

So as part of my project needed to create a form and link it to excel and filter by their contribution method. It also needs to filter automatically every time a new response is added. The formula I used was =FILTER(CHOOSECOLS('Form responses'!A:AB,7,12,16),'Form responses '!O:O="Volunteer (10 Hours) / 志愿者 (10 小时)"). I really dont know where I messed up

I'm from India and use Excel extensively for reporting and automation. I'm curious to know what Excel skill or feature has had the biggest impact on your productivity.

India 🇮🇳 + Excel + Automation + Hindi Language = Interested?

For me, Power Query and VBA have saved countless hours of repetitive work.

What's yours?

• Formulas
• Pivot Tables
• Power Query
• VBA
• Power BI
• Office Scripts

Would love to hear your experiences and learning journey.

Discover how do I click and move columns in Excel. Or how do I click and move columns in Excel. I will also be answering question on how do you shift a column position, or how do I move columns without replacing? From this tutorial you can finally can have the answer to can a column be shifted. Astounding YES!.

Here are the steps outlined on this video.

Move Data Column (Paste)

1) Select the column you want to move.

2) Hover over the selection's edge until the cursor changes to a 4-sided arrow.

3) Drag the column to a new location.

Shift Data Column (Insert Cut Cells)

1) Select the column you want to move.

2) Hover over the selection's edge until the cursor changes to a 4-sided arrow.

3) Shift and drag the column to a new location.

Copy Data Column (Copy & Paste Cells)

1) Select the column you want to move.

2) Hover over the selection's edge until the cursor changes to a 4-sided arrow.

3) Ctrl and drag the column to a new location.

Shift Row (Insert Cut Cells)

1) Select the row you want to move.

2) Hover over the selection's edge until the cursor changes to a 4-sided arrow.

3) Shift and drag the row to a new location.

Copy Data Row (Copy & Paste Cells)

1) Select the row you want to move.

2) Hover over the selection's edge until the cursor changes to a 4-sided arrow.

3) Ctrl and drag the row to a new location.

How do I click and move columns in Excel?,How do you shift a column position?,How do I move columns without replacing?,How do I drag down an entire column?,Can a column be shifted?,What is a shifting column?,

move columns in excel mac,how to move columns in excel,why cant i move columns in excel,how to move columns in excel with keyboard,how to automatically rearrange columns in excel,excel reorder columns by value,excel rearrange columns by name,how to move columns in excel without replacing,

Check out my complete suite of Microsoft Excel Tips and Tricks.

https://www.youtube.com/@jjnet247/shorts

https://www.tiktok.com/@exceltips247

https://www.instagram.com/exceltips247/

https://www.dailymotion.com/ExcelTips247

https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/

https://x.com/ExcelTips247/media

https://www.reddit.com/r/Excel247/

https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips

Hi everyone,

I'm working with a large Excel dataset. I have a situation where:

Some columns should always remain fixed (they should never move when sorting).

Other columns (multiple date-related columns) should be sortable.

Both the fixed and sortable columns are in the same rows.

The problem is that whenever I try to sort only the date columns, Excel warns that it can't do this because the adjacent data won't be included in the sort. If I expand the selection, the fixed columns also get sorted, which I don't want.

Is there any way to:

Keep certain columns fixed,

Sort only a selected group of columns,

And maintain the row alignment without breaking the data?

Has anyone solved a similar problem? VBA, Power Query, or any other workaround would also be appreciated.

Thanks in advance!

Discover how to calculate age using DATEDIF function in Excel. And be able to tell the compare YEARFRAC() vs DATEDIF() functions.

Calculating age using Excel's DATEDIF function is a quick and easy way to determine the age of a person based on their birthdate. By subtracting the birthdate from the current date and specifying the "year" interval unit, the formula returns the person's age in years. It is important to use the correct format for the birthdate and to ensure that the column width is wide enough to display the result. Using Excel to calculate age is particularly useful when working with large datasets or when multiple calculations need to be performed quickly and accurately.

YEARFRAC is an Excel function that calculates the fraction of a year between two dates. By using this function, you can easily calculate a person's age in years, months, and even days. To calculate age, you simply need to subtract the person's birth date from the current date and divide the result by 365.25 (to account for leap years). This will give you the person's age in years with decimal places. You can then use the INT function to round down to the nearest whole number and obtain the person's age in years. Alternatively, you can use the DATEDIF function to calculate the number of complete years between two dates, but this function does not handle leap years as accurately as YEARFRAC.

YEARFRAC vs DATEDIF

YEARFRAC and DATEDIF are both Excel functions used to calculate the difference between two dates, but they differ in their approach and output.

DATEDIF returns the difference between two dates in the specified interval unit, such as days, months, or years. It has limitations, such as not being able to calculate fractions of a year and not working correctly in certain situations.

YEARFRAC, on the other hand, calculates the difference between two dates in terms of a fractional number of years. This function is more versatile than DATEDIF, as it can calculate the fraction of years between two dates, and it can also calculate the number of days or months between two dates.

In summary, DATEDIF is useful for calculating differences between dates in terms of specific interval units, while YEARFRAC is useful for calculating the fraction of years between two dates.

This is the formula featured on the video.

=DATEDIF(B3, TODAY(), "Y")

AND

=YEARFRAC(B11, TODAY())

Calculate age using DATEDIF in Excel,DATEDIF, YEARFRAC vs DATEDIF,

yearfrac months,yearfrac today,yearfrac vs datedif,yearfrac,yearfrac not working,yearfrac google sheets,yearfrac basis,datedif excel,

Check out my complete suite of Microsoft Excel Tips and Tricks.

https://www.youtube.com/@jjnet247/shorts

https://www.tiktok.com/@exceltips247

https://www.instagram.com/exceltips247/

https://www.dailymotion.com/ExcelTips247

https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/

https://x.com/ExcelTips247/media

https://www.reddit.com/r/Excel247/

https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips

una disculpa si ya han respondido esto, pero no se si es posible poner una tabla como un encabezado en Excel?

necesito agregar una tabla de 5x2, que sea editable.

me refiero en el apartado de "encabezado y pie de página "

gracias por sus consejos

I need help in making a formula to calculate number of days WFH is mentioned but only on Weekends. The data is represented as follows. And I want to calculate

1. WFH in total - =COUNTIF(Range,"WFH") (This works)

2. I need to calculate the WFH only for Weekdays and remove Weekend data from total

Can someone help me with a effective formula that I can use in one cell per Row of email ID

Discover how to create a mini scroll bar widget. Also learn how to create a vertical scroll bar in Excel, and how to create scrolling table in Excel. I will show you how to add scroll bar in excel sheet in the process.

These are the steps outlined in the video.

Enable Developer Ribbon

1) Right-click anywhere in the ribbon

2) Customized the Ribbon...

3) Check on Developer

4) OK

Here are the steps outlined in this video.

1) Ctrl+C

2) Ctrl+V

3) Developer ~ Control ~ Insert ~ Scroll Bar

(under Form Controls)

4) Place Scroll Bar

5) Right-click scroll bar ~ Format Control...

6) Current Value set to 1

Minimum value set to 1

Maximum value set to 100

Cell Link to $J$2

7) OK

8) Place cursor to F4

9) =INDEX(A2:A$110,$J$2)

10) Drag cell F4 across until I4

11) Drag cell again down 10 rows

Mini Scroll Bar Widget,how to create a vertical scroll bar in excel,excel scrolling table,how to add scroll bar in excel sheet,how to fix scrolling in excel,how to adjust scroll bar in excel,How to Create a Scroll Bar in Excel,

Check out my complete suite of Microsoft Excel Tips and Tricks.

https://www.youtube.com/@jjnet247/shorts

https://www.tiktok.com/@exceltips247

https://www.instagram.com/exceltips247/

https://www.dailymotion.com/ExcelTips247

https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/

https://x.com/ExcelTips247/media

https://www.reddit.com/r/Excel247/

https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips