My name is Alexander Frolov. I have been at Ablebits from its very first days starting my career as a web-master. After I mastered all the cobwebs of HTML and XHTML I aimed my efforts into another direction, and now I run the department of end-user software. We create add-ins for Microsoft Outlook, Excel and Word, and do some testing and bug finding for our Add-in Express guys along the way :).
I like spending time with my wife, my daughter, cat and friends. I'm also keen on good rock music and science fiction - Isaac Asimov, Stanislav Lem, Neal Stephenson etc.
Here is a list of Alexander's recent articles:
Outlook auto signature: how to add and change
How to delete multiple emails and folders in Outlook
How to add image / photo to Outlook email signature
How to create Outlook email template with images
How to add a shared mailbox in Outlook
How to start Outlook in safe mode
How to set image as background for Outlook email / template
How to find path to outlook.exe file and use command line switches
How to share Outlook email templates in classic, new and web app
How to send HTML email in Outlook and prevent from converting to plain text
Adding Gmail account to Outlook: guide for classic and new app
How to schedule an event for multiple dates on Outlook
How to add emoji to Outlook email subject line
How to add HTML signature to Outlook
How to make, add and change signatures in new Outlook and web
Color categories in new Outlook and web: create, use, sort and filter
Outlook categories: how to create, use, change, search and filter
Outlook Inbox not updating - reasons and fixes for classic, new and web app
How to clear Outlook cache in new app and classic version
How to use custom Lambda functions in Excel GROUPBY and PIVOTBY formulas
Quick Steps in new Outlook and web: how to create, use, manage
How to update Outlook: new app and classic version
How to run classic (old) Outlook and new Outlook side by side
Auto-format Excel GROUPBY and PIVOTBY results with conditional formatting
How to insert HTML into Outlook email
New Outlook ribbon: customize and change from simplified to classic
Excel PIVOTBY function - formula alternative to pivot tables
Conditional formatting in new Outlook and web to highlight emails
Excel GROUPBY function to group rows and aggregate values
Primary account in new Outlook: how to change and why it matters
Cannot add account in new Outlook: reasons and solutions
How to add, manage and delete account in new Outlook
How to save Outlook email message as PDF: single, multiple, with attachments
How to print Outlook contacts
How to print calendar from Outlook in desired date range and style
How to print emails and attachments in Outlook
How to change time zone in Outlook: classic, new app and web
How to forward or redirect email from Outlook automatically
Outlook rules not working automatically: errors and fixes
How to create email rules in new Outlook and Outlook 365 online
Outlook rules with examples: how to create, edit and remove
Outlook conditional formatting: color-code or highlight emails, calendar and tasks
How to schedule send in new Outlook and web app
How to create an email template in new Outlook and web app
How to create timeline for Excel pivot tables and charts
How to make pivot charts in Excel
How to use Copilot in Excel with examples
Copilot in Outlook: how to get, enable and use
XLOOKUP vs INDEX MATCH in Excel: which is better and faster?
XLOOKUP vs VLOOKUP in Excel: differences and advantages
Excel XLOOKUP with multiple criteria
Chat GPT for Outlook email writing
How to create an email group (contact group) in Outlook
Block Outlook emails: from certain countries, with specific words
How to repeat the last action in Excel with shortcut or command
How to redo in Excel: comprehensive guide
How to block email sender in Outlook and manage blocked list
How to insert emoji and smiley in Outlook
Excel Quick Analysis tool with examples
How to use Power Query in Excel – practical examples
Power Query in Excel tutorial: how to get, use and auto-refresh
Excel formula to get day of week from date
Excel crashes or freezes when highlighting cells in big datasets: reasons and solutions
Adding second axis in Excel: chart with two X or Y axes
How to omit / remove the first line in Excel cell
How to undo in Excel: shortcut, multiple actions, not working
How to select rows and columns in Excel
How to select multiple cells in Excel: non-adjacent, visible, with data
Excel status bar not showing sum, average or count
Excel status bar missing: how to get it back
Excel Status Bar: options, customization and efficiency tips
How to create Outlook email template with attachments
How to calculate standard error of the mean in Excel
#NUM error in Excel - fixing number error in formulas
Create drop down list with color in Excel and Google Sheets
#VALUE error in Excel: causes and fixes
#NAME error in Excel: reasons and fixes
What # sign means in Excel and how to remove #### from cell
How to find all combinations of numbers that equal given sum in Excel
Check if value exists in range / column in Excel and Google Sheets
How to edit, copy and delete drop down list in Excel
How to sort mixed numbers and text, hierarchy numbers in Excel
How to use EDATE function in Excel with examples
CHOOSECOLS function in Excel to get columns from array or range
CHOOSEROWS function in Excel to extract rows from array
How to use NOW function in Excel to get current date and time
Excel EXPAND function to grow array to specified number of rows and columns
Excel DROP function to remove rows or columns from range or array
How to insert current time in Excel: timestamp shortcut, formula, VBA
Excel TAKE function to extract rows or columns from array
Convert column / row to range in Excel: WRAPCOLS & WRAPROWS functions
Excel AVERAGEIFS function with multiple criteria
Excel AVERAGEIF function to average cells with condition
Excel AVERAGE function to find arithmetic mean
Excel TOROW function to convert range / array to single row
Excel conditional formatting Color Scales
Data Bars in Excel: how to add and customize
Excel TOCOL function - convert range to single column
Excel IMAGE function - quick way to insert picture in cell with formula
Excel conditional formatting for blank cells
How to combine ranges / arrays in Excel with VSTACK & HSTACK functions
Excel: check if two cells match or multiple cells are equal
Excel IF statement between two numbers or dates
TEXTSPLIT function in Excel: split cells / text strings by delimiter
How to extract text between two characters or words in Excel and Google Sheets
Excel TEXTAFTER function: extract text after specific character or word
Excel TEXTBEFORE function - extract text before character (delimiter)
SUMIF between two numbers in Excel and Google Sheets
Case-sensitive SUMIF and SUMIFS in Excel and Google Sheets
How to group columns in Excel
How to find sum of largest N numbers in Excel
SUMIF multiple columns with one or several criteria in Excel
How to make a heat map in Excel with or without numbers
Use the new Excel IFS function instead of nested IF
Excel SWITCH function - the compact form of nested IF statement
5 ways to sum a column in Excel
How to convert numbers to text using Excel TEXT function and other options
How to add columns in Excel: single, multiple, every other
How to remove rows in Excel based on a cell value
How to unhide and show hidden columns in Excel
How to insert page numbers in Excel
How to insert and remove page breaks in Excel
How to rotate charts in Excel - rotate bar, column, pie and line charts
3 ways to count empty cells in Excel
How to count non-empty cells in Excel
Easily print comments in Excel
How to insert multiple rows in Excel: shortcut, right-click, VBA
How to import contacts to Outlook from Excel in 3 steps
How to use AutoFill in Excel - all fill handle options
How to replace formulas with their values in Excel
How to insert and run VBA code in Excel - tutorial for beginners
How to remove carriage returns (line breaks) from cells in Excel
3 ways to remove spaces between words / numbers in Excel cells
How to quickly extract domain names from URLs in Excel
How to prevent duplicates in a column in Excel
How to merge two columns in Excel without losing data
How to set automatic out of office reply (away message) in Outlook
How to remove all blank rows in Excel
How to enter the same data (formula) into all selected cells at a time
How remove multiple (all) hyperlinks from Excel worksheets at a time
How to compare two columns in Excel and delete duplicates (highlight, color, move)
How to sort in Excel by row, column names and in custom order
Two best ways to convert numbers to words in Excel
How to save Excel chart as image, copy or export it to Word & PowerPoint
"Outlook Not Responding" error - solutions for hanging, freezing and crashing problems
How to view Outlook Email Headers (internet headers)
30 most useful Excel keyboard shortcuts
How to avoid automatic data formatting in Excel
Enter multiple lines in a single Excel cell
Get rid of "The file is corrupt and cannot be opened" in Excel