ICAEW.com works better with JavaScript enabled.

Worksheet design and formatting

View a list of articles and webinars produced by the Excel Community on worksheet design and formatting.

Displaying 1-20 of 257 results
Simon Hurst
Exclusive Excel’s real-life superpowers
  • Article
  • 24 Oct 2024
  • Simon Hurst
Useful as some features are when used in a spreadsheet, they could be even more empowering if available in real-life. In this article we consider some examples and explore the use of AI in illustrating the possibilities.
Simon Hurst
Exclusive Multiple conditional formats
  • Article
  • 18 Oct 2024
  • Simon Hurst
It is possible to apply multiple conditional formats to the same cell or range of cells. Where rule formats don’t clash with other rules, then all the rules that satisfy the condition will be applied. However, where rules are mutually exclusive, for example where they both change the font colour, rules are evaluated in a specific order of priority. In this article we look at making sure that your rules are in the right order.
Headshot of Mark Proctor
Exclusive Using slicers with PIVOTBY, GROUPBY and FILTER
  • Article
  • 01 Oct 2024
  • Mark Proctor
The newest functions, GROUPBY and PIVOTBY will be rolling out to users over the next few months. In this article, we uncover the techniques we can implement for using slicers with these new functions.
Headshot of Ian Pay
Exclusive EXCEL TIP OF THE WEEK Excel Tips and Tricks #495 - Excel “Tick”ery!
  • Article
  • 27 Sep 2024
  • Ian Pay
Welcome back to Excel Tips and Tricks! For our latest tip, we have a General User post exploring one of the latest pieces of Excel functionality – Checkboxes.
Simon Hurst
Exclusive SIMPLE BUT EFFECTIVE TABLES Simple but effective tables, part 6
  • Article
  • 03 Jul 2024
  • Simon Hurst
In this series we are going to examine some of the capabilities of Excel Tables. We will be concentrating on the practical use of Tables to improve spreadsheet productivity. The last article finished with a brief introduction to the use of Slicers as interactive filters for Excel Tables. This time we show how Slicers can be used in practice to create an interactive dashboard from an Excel Table.
Simon Hurst
Exclusive SIMPLE BUT EFFECTIVE TABLES Simple but effective tables, part 5
  • Article
  • 24 Jun 2024
  • Simon Hurst
In this series we are going to examine some of the capabilities of Excel Tables. We will be concentrating on the practical use of Tables to improve spreadsheet productivity. As part of our journey through the capabilities of Tables, this time we are going to examine some of the options available in the contextual Table Design Ribbon tab.
Lego graph image
The easy way to implement Excel principles
  • Article
  • 13 Jun 2024
  • PerfectXL
What unites accountants? Excel, of course! I’m sure you'll agree that Excel's integral role in accountancy demands that spreadsheets meet certain standards, but that is easier said than done. In this article, PerfectXL explore what exactly you should be mindful of when working in Excel.
Headshot of Bani Lamba
Exclusive EXCEL TIP OF THE WEEK Excel Tips & Tricks #490 – Revisiting data entry shortcuts
  • Article
  • 21 May 2024
  • Bani Lamba
Hello and welcome back to Excel Tips and Tricks! This week, we have a Basic User level post revisiting simple keyboard shortcuts that helps expedite entry of data into Excel.
Simon Hurst
Exclusive SIMPLE BUT EFFECTIVE TABLES Simple but effective tables, part 2
  • Article
  • 18 Apr 2024
  • Simon Hurst
In this series we are going to examine some of the capabilities of Excel Tables. In part 1 we considered different ways of turning a range of cells into an Excel Table and demonstrated the importance of Tables in helping to ensure that ranges in formulas adapt automatically to changes in the dimensions of the Table. This time, we will look in more detail at adding rows and columns to existing Tables and see how this can contribute to automating your spreadsheets.
Simon Hurst
Exclusive Including calculations in Microsoft Word
  • Article
  • 27 Mar 2024
  • Simon Hurst
Excel might be the obvious application for all sorts of calculations, but Word also has a calculation feature based on Field Codes that can perform simple calculations, use some functions and also format the result.
Headshot of Bani Lamba
Exclusive YOUR QUESTIONS ANSWERED Your Questions Answered #10 – Tips and Tricks Live extended
  • Article
  • 25 Mar 2024
  • Bani Lamba
In this year’s first 'Excel Tips and Tricks live – your questions answered' webinar, John Yeldham and Ian Pay tackled Excel questions and queries covering best practice, the use of functions and functionality, and a range of techniques for data handling and analysis in Excel. Bani returns to answer some of the unanswered questions from the webinar.
Simon Hurst
Exclusive Don’t be a check box Charlie
  • Article
  • 26 Jan 2024
  • Simon Hurst
In preparation for a very useful enhancement to the Excel check box feature that is currently available to those on the Insider update channel, we take a look at how check boxes work at the moment before seeing how much easier they will be to use in the near future.
Headshot of Bani Lamba
Exclusive EXCEL TIP OF THE WEEK Excel Tips & Tricks #486 – Revisiting inserting hyperlinks
  • Article
  • 12 Jan 2024
  • Bani Lamba
Hello and welcome back to Excel Tips and Tricks! This week, we have a Basic User level post in which we take look another look at how to create hyperlinks in your file, to aid quick navigation. We will also cover the differences between hyperlinks in Excel Online and the desktop versions.
Simon Hurst
Exclusive Animated Excel Christmas tree follow-up
  • Article
  • 08 Jan 2024
  • Simon Hurst
Following the response to our 2023 Christmas special, we are extending our interactive Excel Christmas card to demonstrate some additional Conditional Formatting techniques.
Simon Hurst
Exclusive Animated Excel Christmas tree
  • Article
  • 19 Dec 2023
  • Simon Hurst
What better way to spread Christmas cheer than by sending someone an interactive Excel Christmas tree? In this article we use a range of techniques including conditional formatting, Dynamic Arrays and a LAMBDA() function to bring some added sparkle to Christmas.
David Beniam
NEW TECH FEATURES New tech features for Sep - Nov 2023
  • Article
  • 19 Dec 2023
  • David Benaim
David Benaim presents a digest of new features across Microsoft 365 and other business tech products in written, images and video format, covering the last three months.
Liam Bastick
Exclusive Histogram Hiccoughs part 2
  • Article
  • 27 Oct 2023
  • Liam Bastick
Last time, I provided several reasons why Excel’s built-in Histogram charts can cause problems. This time, I consider workarounds to achieve the same visualisations.
Headshot of Ian Pay
Exclusive EXCEL TIP OF THE WEEK Excel Tips & Tricks #481 – Refreshing Cell Styles
  • Article
  • 20 Oct 2023
  • Ian Pay
Hello all and welcome back to Excel Tips and Tricks! This week, we have a General User post in which we're revisiting the topic of cell styles to help support consistency of formatting.
Simon Hurst
Exclusive Advanced conditional formatting – part 3: the horror of peril sensitivity
  • Article
  • 02 Oct 2023
  • Simon Hurst
Applying default conditional formats is very straightforward and can be accomplished with just a couple of clicks, but delving a little deeper can help you to use conditional formatting in additional ways and to tailor your format to your own requirements. After looking in part 1 at some of the more advanced ways to use cell formats as part of conditional formatting and in part 2 at the graphical conditional formats, this time we will look at some other uses of conditional formatting including how it works with PivotTables and Power Query tables as well as some more unusual applications of con...
Lego graph image
EXCEL COMMUNITY ROUND UP Excel Community round up - September 2023
  • Article
  • 02 Oct 2023
  • Tracy Gray
Here are all the new Excel blogs from the Excel Community in September 2023.
Displaying 1-20 of 257 results

Search the Excel Community archive

This archive of Excel Community content from the ION platform will allow you to read the content of the articles but the functionality on the pages is limited. The ION search box, tags and navigation buttons on the archived pages will not work. Pages will load more slowly than a live website. You may be able to follow links to other articles but if this does not work, please return to the archive search. You can also search our Knowledge Base for access to all articles, new and archived, organised by topic.

Search the archive Access the knowledge base
Excel polaroid