Excel Magic Trick #504: 3D Formatting For Cells Using Borders




About this tutorial:

Video duration: 2:41
See how to use the Borders tab in the Format Cells dialog box to create a 3D effect to Cells.

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

9 thoughts on “Excel Magic Trick #504: 3D Formatting For Cells Using Borders

    ExcelIsFun

    (September 23, 2017 - 3:44 pm)

    Cool!

    Rajesh Bhat

    (September 23, 2017 - 3:44 pm)

    If you want to create 3 D effect for only one cell, you could apply thin white border to top and left border, and thick black border to right and bottom borders. It looks like the cell is popping out leaving a shadow behind

    ExcelIsFun

    (September 23, 2017 - 3:44 pm)

    I don't understand what you are trying to do.

    ExcelIsFun

    (September 23, 2017 - 3:44 pm)

    Playlist name: Excel Randomizing Tricks

    some videos:

    Excel Magic Trick 276 MoreFunc Excel add-in 66 New functions

    Excel Magic Trick 302: Randomly Select Names No Repeats

    Excel Magic Trick 373: Randomize…

    ExcelIsFun

    (September 23, 2017 - 3:44 pm)

    I already have videos on Random picking without duplicates. Go to the excelisfun channel, go to playlist, find the playlist that has randomization tricks. There are two or three videos on "Random picking without duplicates".

    Helal Ahmed

    (September 23, 2017 - 3:44 pm)

    Thank you. Is there any chance you could do a video on soccer fixtures etc… i.e from a selection of 10 teams, have random fixtures but have each team play each other but only Once and also have the table update and also have the QF SM AND FINAL Fixtures update. Thank you

    You are awesome and your response is very quick

    ExcelIsFun

    (September 23, 2017 - 3:44 pm)

    Try these videos:

    Excel Magic Trick # 273: Extract Top 5 Records w Formula

    Excel Magic Trick 337: RANK function 10 Examples

    Excel Magic Trick 471: Sort Horizontal With Formula 3 Examples

    Helal Ahmed

    (September 23, 2017 - 3:44 pm)

    If 2 teams have the same points i want to table to update with the teams with the best goal difference, if that is the same then i want it to update by the team who has scored the most goals, if that is alos the same then i want it to update by the team who has conceded the least.

    i,e (P=PLAYED, W = WON, D = DRAW = L=LOSS, GS = GOALS SCORED, GC = GOALS CONCEDED, GD = GOAL DIFF (GS – GC = GOAL DIFF)

    Helal Ahmed

    (September 23, 2017 - 3:44 pm)

    Thank you
    You are the best
    How long did it take you to become an excel expert knowing all these functions? i wish i could be like you 1 day.

    Need some help, im trying to do a soccer table (i .e 6 teams in 1 group, 3 groups altogether). 3 points for a win, 1 point for draw and 0 points for loss). I want to be able to have the table update from 1 to 6 based on whoever has the most points. I can use the rank function however i cant get it to update 1 to 6 in a row.

Leave a Reply

Your email address will not be published. Required fields are marked *