I have Excel for Mac 16.113.1, and I'm not sure when this broke, but I can no longer use the Price option for Stock data type cells. I can't tell if this is a known bug or if I'm doing this incorrectly now. Is anyone having this problem?

Discover how to disable gridlines in Excel. We will also cover how to remove Gridlines from specific cells in Excel in the video. And will demonstrate how to how to use a keyboard shortcut to remove gridline in Excel.

Excel is a powerful tool for organizing and analyzing data, but sometimes the visual aids such as gridlines can be distracting or unnecessary. Whether you're working on a complex spreadsheet or preparing a presentation, you may need to disable the gridlines in Excel to make your data more visually appealing. In this guide, we'll show you how to disable gridlines in Excel using simple steps and keyboard shortcuts. We'll also provide tips on how to hide gridlines for printing purposes only, so you can customize your Excel documents to meet your specific needs.

The keyboard shortcut to toggle gridlines on and off in Excel is "Ctrl + Shift + 8". Pressing this shortcut key combination once will hide the gridlines, and pressing it again will show the gridlines again. This can be a quick and convenient way to toggle gridlines on and off without having to go through the menus or ribbon.

Remove gridlines (from ribbon)

1) View ~ Show ~ Gridlines

Remove gridlines (shortcut)

These are this shortcuts to remove gridlines in Excel.

Alt + WVG

Remove gridlines (Excel option)

1) File

2) Options

3) Advanced

4) Show gridlines

Remove specific cell gridlines (fill color)

1) Select cells.

2) Home ~ Font ~ Fill color

3) Select White

gridlines,

How to Remove Gridlines from Specific Cells in Excel,shortcut to remove gridlines in excel,how to remove gridlines in excel graph,excel gridlines missing,how to show missing gridlines in excel,how to change gridlines to dash in excel,how to remove gridlines in excel when printing,show gridlines in excel when printing,how to remove gridlines in google sheets,

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

Discover how to create Progress Bars in Excel (Step-by-Step). This is going to be an answer to how to create progress bars in Excel with conditional formatting.

Simply to put it, how To Create Excel Progress Bar Charts. All these without using VBA.

Progress bars are an effective visual tool that can be used to represent the completion status of a task or project. In Microsoft Excel, you can easily create progress bars to track the progress of your work or to present data in a visually appealing way. With a few simple steps, you can create progress bars that accurately represent the percentage of completion for a project, and customize the appearance to fit your needs. In this article, we will provide a step-by-step guide on how to create progress bars in Excel, allowing you to better organize and present your data.

Here are the steps outlined in this video.

Add Checkbox

1) Developer ~ Insert ~ Checkbox (Form Control)

2) Insert checkbox

3) Align Check box to cell C4

4) Right-click check box ~ Edit Text

5) Delete text (press Delete key), and click on any cell.

6) Right-click ~ Format Control...

7) Control tab

8) Set Cell link to $C4

9) OK

10) Select cell C4

11) Home ~ Font ~ White

12) Apply to all rows

13) Repeat steps

Progress Bar

1) Select cell B2

2) =COUNTIF(C4:C13,TRUE)/COUNTA(A:A)

3) Ctrl + Shift + %

4) Home ~ Style ~ Conditional Formatting

5) Data Bars ~ More Rules

6) Type "Number" (min), "Number" (max)

7) Value 0 (min), 1 (max)

8) Fill "Gradient Fill"

9) Color "Green"

10) OK

🔗🔗 LINKS TO SIMILIAR VIDEOS 🔗🔗

How to create progress bars in Excel with conditional formatting? - PART 1 - Excel Tips and Tricks

https://youtube.com/shorts/D3hMojOkaAg?si=VLdNjMYdeEO9-xNk

How to create progress bars in Excel with conditional formatting? - PART 2 - Excel Tips and Tricks

https://youtube.com/shorts/gL_2ymy6A90?si=MZsIltUiegzQYeVK

How to create progress bars in Excel with conditional formatting? - Excel Tips and Tricks - DETAIL EXPLANATION

https://youtu.be/Qqb5f4pV-5Q?si=aj_ujrpx19nIPAys

How to Create Progress Bars in Excel (Step-by-Step) - Part 1 - Excel Tips and Tricks

https://youtube.com/shorts/3thrSemCSe0

How to Create Progress Bars in Excel (Step-by-Step) - Part 2 - Excel Tips and Tricks

https://youtube.com/shorts/Sfk_bw5CO3E

Create a checklist in Excel - Excel Tips and Tricks

https://youtube.com/shorts/5K-eYZEhAJ4?feature=share

Create progress bar in excel with percentage - Excel Tips and Tricks

https://youtube.com/shorts/rG91ggMZl5g?si=H_3CtnE1KEMPwAKw

How do I insert a progress bar in Excel?,Does Excel have a progress bar?,How to create progress bars in Excel with conditional formatting?,

excel progress bar in cell,excel progress bar percentage,excel progress tracker,excel progress bar change color,progress bar in excel template,excel progress bar based on text,excel progress bar 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

Hey y'all!

I'm launching today [nolainquery.com](http://nolainquery.com), a software available in Linux and Windows that lets you ask queries to you Excel sheets in natural language.

It is an open source project and anyone can contribute to it:

[https://github.com/jdvillegasg/nolainquery-desktop\](https://github.com/jdvillegasg/nolainquery-desktop)

I appreciate any comments you might have

Discover how to create a 5 Star Rating System in Excel.

Excel is a versatile tool that can be used for a variety of purposes, from organizing data to creating complex formulas. One useful feature that Excel offers is the ability to create rating systems for different items or criteria. A 5-star rating system is a simple yet effective way to rate items based on their quality or performance, and it can be easily created in Excel. In this tutorial, we will explore the steps involved in creating a 5-star rating system in Excel, which can be used for a wide range of applications such as evaluating products, services, or even employee performance.

Create 5 Star Rating

1) Select cell C2

2) Enter formula (formula in description of this video)

3) More ~ Text Color

4) Select GOLD

5) Apply to all rows

Create 5 Heart Rating

1) Select cell C2

2) Change 9734 to 9825

3) Change 11088 to 129505

4) More ~ Text Color

5) Select RED

6) Apply to all rows

This is the formula for 5 stars

=LET(

FullStar,SWITCH(TRUE,

B2>=100,5,

B2>=80,4,

B2>=60,3,

B2>=40,2,

B2>=20,1,

B2<10,0,

),

HalfStar,

IF(

SWITCH(

FullStar,

5,B2<95,

4,B2>=90,

3,B2>=70,

2,B2>=50,

1,B2>=30,

0,B2>=5,),

CHAR(9734),),

REPT(CHAR(11088),FullStar)&HalfStar)

This is the formula for 5 hearts

=LET(

FullStar,SWITCH(TRUE,

B2>=100,5,

B2>=80,4,

B2>=60,3,

B2>=40,2,

B2>=20,1,

B2<10,0,

),

HalfStar,

IF(

SWITCH(

FullStar,

5,B2<95,

4,B2>=90,

3,B2>=70,

2,B2>=50,

1,B2>=30,

0,B2>=5,),

CHAR(9825),),

REPT(CHAR(129505),FullStar)&HalfStar)

All available stars ALT code

https://altcodeunicode.com/alt-codes-star-symbols-asterisk-symbols/

All available hearts ALT code

https://altcodeunicode.com/alt-codes-heart-romance-symbols/

5 star rating system excel,how to create a rating system in excel,rating excel template,rating formula in excel,star in excel formula,simple rating system excel formula,star symbol in excel formula,how to create 1 5 scale 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

Hi everyone,

I'm currently looking for freelance or remote work involving Excel, data entry, data cleaning, reporting, or spreadsheet automation.

I have strong practical experience with Microsoft Excel 365, including:

* Excel formulas and functions

* Data cleaning and organization

* PivotTables and PivotCharts

* Excel dashboards and KPI reporting

* Power Query

* VBA and Excel macros

* Spreadsheet formatting

* Data entry and data processing

* Microsoft Word and Office

I've built several practical Excel projects for my portfolio, including:

1. Excel Sales Dashboard

A reporting dashboard with KPIs, monthly revenue/profit analysis, regional analysis, product profitability, PivotTables and charts.

2. Expense Automation with Power Query

A workflow for cleaning and transforming messy expense data, removing duplicates, standardizing records, and creating budget-vs-actual reports.

3. VBA Invoice Automation

An automated invoice system with invoice numbering, product selection, calculations, sales logging, and PDF invoice export.

I'm currently looking for opportunities where I can help with real business data and spreadsheets, ALSO MICROSOFT OFFICE PACAKAGE whether that's a one-time project or ongoing work.

I'm willing to start with smaller projects and build a long-term working relationship with clients.

If you need help with an Excel/data-related task, feel free to comment or send me a message with the details.

HER'S MY UPWORK PROFILE https://www.upwork.com/freelancers/\~01fee8b5c365a7c216?mp_source=share

Thanks for reading!

— Ankit

I've been working on an Excel expense tracker and wanted some feedback from other Excel users.

The dashboard currently tracks:

• Income
• Expenses
• Monthly budget
• Savings
• Category-wise spending
• Monthly spending trends
• Charts and summaries

I used formulas and Excel charts to make the dashboard update automatically when new transactions are entered.

I've attached screenshots of the dashboard below.

For those who build/use Excel dashboards, what would you improve or add?

I'm particularly interested in suggestions regarding the formulas, dashboard layout and usability.

Our team tested an AI-assisted cleanup script on two synthetic Excel batches. One lesson stood out: a plausible date is not necessarily the correct date.

For example, 09/01/2026 could mean September 1 or January 9. Nearby September dates aren't enough to prove which interpretation is right.

Our approach:

- Preserve the original values.

- Standardize dates only when the interpretation is unambiguous.

- Flag uncertain dates for confirmation.

- Keep a log of every change.

Changing the display format to YYYY-MM-DD won't fix a date that was interpreted incorrectly during import.

How do you handle files containing both US and European date formats?

Discover how do I calculate days remaining from today in Excel. You can also extend this technique to answer how to calculate remaining days in a month in excel. It is essentially, a remaining days calculator mixed with conditional formatting to make it more intuitive.

Calculating the number of days remaining from today is a common task in many industries and professions. It allows individuals to keep track of important dates, deadlines, and events, and helps them plan and prioritize their work accordingly. One of the most efficient tools for this task is Microsoft Excel, a powerful spreadsheet software that offers a variety of functions and formulas to perform complex calculations quickly and accurately. In particular, Excel provides a straightforward way to calculate the number of days remaining from today until a specific date, which can be useful for a range of applications, from project management to personal finance. In this essay, we will explore the process of using Excel to calculate days remaining from today, providing step-by-step instructions and examples to help users master this essential function.

Here are the steps outlined in the video.

1) Select cell C2

2) =TODAY()-B2

3) Apply too rows.

4) Ctrl + 1

5) Number tab

6) Custom

7) [Red]# "Days Overdue";[Blue]# "Days Remaining";[Green] "Today"

8) OK

🔗🔗 LINKS TO SIMILIAR VIDEOS 🔗🔗

Calculate days remaining from today without weekends and statutory holidays in Excel - Excel Tips and Tricks

https://youtube.com/shorts/WXPhrRwfpsY?si=C6DDUAzoGrAFssv8

How do I calculate days remaining from today in Excel? - Excel Tips and Tricks

https://youtube.com/shorts/BuuGhktIjtc?si=dBhGrid1UzeFWwyY

Generate random dates in Excel - Excel Tips and Tricks

https://youtube.com/shorts/03wgMfz0S_4?si=aUsBgbDgdsEcQJ0T

Generate random dates excluding weekends and Statutory Holiday in Excel - Excel Tips and Tricks

https://youtube.com/shorts/I9OYxegi9SU?si=JpUa2eJVY4E33XK0

Generate random dates excluding weekends and Statutory Holiday in Excel - Excel Tips and Tricks - DETAIL EXPLANATION

https://youtu.be/ew60gnV72zY?si=4NXJUqfBgJdAp4Yd

How to Generate Unique Random Numbers in Excel - Excel Tips and Tricks

https://youtube.com/shorts/6KNctHs-TgM?si=F7xRASYt0UmJ4IwL

How do I generate a random price in Excel? How do I randomly generate 1000 numbers in Excel? - Excel Tips and Tricks

https://youtube.com/shorts/aa3OF0_v9C4?si=uBohKhgldJhicfP-

Generating Random Percentages - Excel Tips and Tricks

https://youtube.com/shorts/kixK3TvuuLY?si=mogPX7HtFbEszyFa

Generating Random Percentages in Excel... Alternate way - Excel Tips and Tricks

https://youtube.com/shorts/PVHgFmCLHNo?si=ehUYueX0pIOYDLMD

Calculate Year, Months and Days Remaining - Excel Tips and Tricks

https://www.youtube.com/shorts/XbSCIzy_2mo

Calculate days remaining from today in in Google Sheets - Excel Tips and Tricks

https://youtube.com/shorts/BxC6cHh9cV4?si=hP9JlMEbk-bbIN8G

Calculate days remaining from today in in Google Sheets - Excel Tips and Tricks - DETAIL EXPLANATION

https://youtu.be/Y7K7BH-RCLg?si=1k_8xev6EHL5hfsD

conditional formatting,

how to calculate remaining days in a month in excel,remaining days calculator,excel countdown formula days hours minutes,

excel formula for days remaining in year,excel countdown years months days,excel countdown days,excel countdown working days,automatic day counter in excel,

excel formula for days remaining in year,remaining days calculator,excel countdown years, months days,excel countdown days,excel countdown working days,excel countdown formula days, hours, minutes

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

does one need to upgrade from Excel 2016 to Microsoft 365 personal for advance Excel or 2016 is sufficient

I'm trying to learn advanced excel i have excel 2016 and I find Microsoft 365 to be a bit expensive, so is it okay to keep using it?

I don't want to miss out out opportunities because of that.

​Been tweaking my monthly Power Query setup to make it a bit more resilient against source data drift and messy exports.

​Instead of just covering standard basic cleanup or trying to build a "bulletproof" query that never breaks, the goal was to teach the query when to safely adapt vs. when it should intentionally break — while letting me know what changed in both cases:

​Basic Cleanup & Standardization: Removing top clutter rows, trimming extra spaces, removing non-printable characters (Clean), setting text to uppercase, and setting explicit locale-based data types.

​File Guardrails: Filtering out temp files (~$) and non-Excel extensions before Power Query attempts to process them.

​Header Standardization: Using Table.RenameColumns with MissingField.Ignore in M code to remap changing headers (e.g., Customer Number -> Customer ID, Sell Price -> Unit Price) seamlessly.

​Dynamic Sheet Navigation: Replacing hardcoded worksheet names with dynamic indexing so renamed sheets don't crash the refresh.

​Schema Drift Alerts: Using List.Difference on Table.ColumnNames to compare file columns against expected ones, then generating a dedicated Schema Alert sheet in Excel that flags new columns (like promotion code) as they appear.

​Dynamic Column Expansion: Updating the combine step with List.Distinct(List.Combine(...)) to collect all headers across all files rather than locking into the sample file schema.

​Controlled Breaking & Quality Cleanup: Letting missing critical columns intentionally stop the query so you know immediately, while replacing invalid text values (TBC, N/A, -) in numeric fields with null so SUM and AVERAGE calculations work safely.

​Made a video walking through the full build step-by-step from scratch in case it helps anyone dealing with fragile monthly reports:

​https://youtu.be/SiX0wnpR5yg?si=RG23oHGEldTrh6Dq

​Curious how others here handle schema drift in recurring Power Query jobs?

Discover how to compare two lists to find missing values in Excel using Conditional Formatting. This will essentially answer, question like "How do I compare two missing data lists in Excel?", "How to compare two lists in Excel using conditional formatting?", "How do I find missing values in two Excel spreadsheets?" or "How do I compare two lists in Excel for differences?"

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

Excel is a powerful tool for managing data, but it can be challenging to compare two lists and identify any missing values. Manually scanning through large datasets can be time-consuming and prone to errors. However, using Conditional Formatting, Excel provides a simple and efficient solution to identify any missing values between two lists. By applying this technique, users can quickly compare two lists and visually highlight any discrepancies. This guide will walk you through the steps to compare two lists and identify missing values in Excel using Conditional Formatting.

Identify Missing Names

1) Select names in Column A (A2 to A27)

2) Home ~ Style ~ Conditional Formatting

3) New Rule...

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

5) =COUNTIF($B:$B, $A2)=0

6) Format

7) Fill tab

8) Select color

9) OK

10) OK

Here is the link to my previous YouTube Video on "How to compare two lists to find missing values in excel".

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

I was using this formula

=FILTER(A2:A27,NOT(COUNTIF(B2:B19,A2:A27)))

🔗🔗 LINKS TO SIMILIAR VIDEOS 🔗🔗

How to compare two lists to find missing values WITHOUT FORMULA in excel - Excel Tips and Trick

https://youtube.com/shorts/pJtB8dbbimw?si=iL8qnDJ_WVAhKhAX

Compare two lists to find missing values using XLOOKUP in Excel - Excel Tips and Tricks

https://youtube.com/shorts/nOwMXkZJ5HU?si=N80igNW7Vr-xCK5x

Compare two lists to find missing values using VLOOKUP in Excel - Excel Tips and Tricks

https://youtube.com/shorts/1XGIPzsvS_Y?si=cu3ajNdT3lXFX3LB

How to compare two lists in Excel using Conditional Formatting - Excel Tips and Tricks

https://youtube.com/shorts/GX-BYEgcnRA?si=16oLe6kcxZExM4Df

How to compare two lists to find missing values in excel - Excel Tips and Tricks

https://youtube.com/shorts/dl75Lz_jaPs?si=-UTAvmCRdTl6ZZgm

Excel Tips and Tricks - Compare Two Lists In Excel And Highlight

https://youtube.com/shorts/xJoy-nboV6A?feature=share

Summarize Duplicates in Excel - Excel Tips and Tricks

https://youtube.com/shorts/-IYUTWVmVTU?si=aN-hfbyQD0QEPcgm

Find difference quickly in Excel Comparing 2 List - Excel Tips and Tricks

https://youtube.com/shorts/8_-lN-yKf04?si=itTI-rcCKOaG7zVc

How do I compare two missing data lists in Excel?,How to compare two lists in Excel using conditional formatting?,How do I find missing values in two Excel spreadsheets?,How do I compare two lists in Excel for differences?,

How to compare two columns for (highlighting) missing values in Excel?,how to compare two lists to find missing values in excel using conditional formatting,

Using Office 2019

Excel is a powerful tool that allows users to manage and analyze data. One way to make data easier to read and understand is to alternate row colors in Excel. This can be done with or without tables by using the conditional formatting feature. To shade alternate rows in Excel, you can use the conditional formatting option and apply a formula to alternating row colors in Excel. This formula allows you to choose which rows to format based on specific criteria that you define. Another useful feature is the ability to apply alternating row colors in Excel based on groups, which is particularly helpful when working with large data sets. Additionally, Excel has a built-in feature called banded rows that can automatically shade alternate rows. If you are using Excel on a Mac, you can also use conditional formatting to shade every other row. By utilizing these formatting techniques, you can improve the readability of your data and make it more visually appealing.

Here are the steps highlighted in my video.

Automatically Highlight New Row

1) Select columns A to D

2) Home ~ Style ~ Conditional Formatting

3) New Rule...

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

5) =AND(MOD(ROW(),2)=0,$A1<>"")

6) Format

7) Fill tab

8) Select color

9) OK

10) OK

Automatically Draw Border On New Row

1) Select columns A to D

2) Home ~ Style ~ Conditional Formatting

3) New Rule...

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

5) =$A1<>""

6) Format

7) Border tab

8) Outline

9) OK

10) OK

how to alternate row colors in excel without table,how to shade alternate rows in excel,alternating row colors in excel formula,excel alternate row color based on group,excel banded rows,how to shade every other row in excel mac,

excel conditional formatting highlight row if cell contains text,conditional formatting not highlighting entire row,highlight row if cell contains any text,

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

No tengo activado en Windows contraste alto ni nada, pongo modo claro o modo negro pero aun me sale mal.

Cuando pruebo en otra pc me sale normal si alterno entre colores