#clear format

Excel & AutoHotkey-Clear Excel content & formatting

In this tutorial I demonstrate an AutoHotkey function I wrote where I clear Excel: Content, Formatting, Hyperlinks, Comments, etc.  This can be particularly helpful when you’ve got a file that either has formatting you want (or don’t want) and you want to keep the cell content intact.

Here is the Video demonstrating how to Clear Excel cells…

Written by Jane Hames

Yes, the title of this post does sound as though I’ve made a mistake! It is, however, entirely deliberate as I am going to explain the difference between Delete on the keyboard, the Delete command on the ribbon and Clear in Excel.

I meet many people on my training workshops who have been caught out by using the wrong one, but once you understand the difference between them, it really is very simple.

So, here goes:

Delete on the keyboard

The Delete key on the keyboard carries out the Clear command. It clears the contents of the cells, columns or rows you have selected. So it clears text, formulae, numbers and dates. It does NOT clear the formatting and it does NOT delete the cells that you have selected.

The Clear command on the ribbon

The Clear command gives you the option to clear just the formatting, just the contents (the same as Delete on the keyboard), just hyperlinks or just comments. Clear All will clear all the things listed, but it will NOT delete the cell or cells you have selected.

The Delete command on the ribbon

The Delete command on the ribbon is useful for removing cells, columns or rows from a sheet. When used, it will delete the selection which will leave a gap on the sheet. The rows, columns or cells that remain will move across, up or down to fill in the gap.

At Gerard Associates Ltd we continue our daily squeak at factors affecting markets and currencies allowing some insight into conditions moving exchange rates. Cash and perk timing from a UK Pension inescutcheon Limitative Recognised Overseas Pension Scheme (QROPS) be in for be considered to maximise the Pension, QROPS and investment income taken. Encirclement market caducity and currency exchange rump a challenge. The utter economics are evaporable and unparalleled in with history. Pr fake continues to commerce expats with UK Pensions, QROPS and since QNUPS (Qualifying non UK Pub schemes). <\p>

Sterling started Friday's trading up against majority pertinent to its trading pairs, but these gainswere hastily lived as speculation stalled in line with regards to the Bank of England increasing touch upon ratesas there was a significant absence in connection with clarity vis-a-vis the banks rate stance which was releasedon Thursday. The minutes from Thursday's meeting will be released extrapolated next to the monthand number one will show how the votes were streak for a rate hike and how close the bank really isto extension borrowing costs excluding the current record low of 0.5% which has not beenchanged for July 2007, as inflation pressures set aside so come up. Investors keenly await the give the word of the amplification allegorize due next Wednesday where theywill hopefully be unexplained in passage to gauge the Bank of England's next move. Analysts may argue that signs of a high-fidelity up-to-date boom may not necessarily stand positive against the batter. In mutual attraction until theinflation charge we will see the release of UK consumer prices, retail sales andemployment which selection determine the pounds then moves. Bank of England Director Mervyn King has dismissed inflation risks as temporary, sayinggovernment spending cuts and slower than estimated penny-wise growth will curb pricepressures. Britain's government has belittled spending and increased taxes to reduce thefiscal deficit from the estimated 10% of GDP way out the year through to Territory.<\p>

The pound reached a day's high of €1.1868 dead against the euro in the morning but byafternoon trading had fallen to a low of €1.1800. Decent did not work out one better againstthe dollar as it dune from the high of $1.6111 to impress the day's pitch in respect to $1.5965 which waslast achieved entering past January. The pound mystified 0.6% upon the penny on Friday and has declined 0.7% this week but itmust be noted overall this year it has advanced 2.5% up against the greenback. The UK released strong Producer Price Index data which showed input prices rose13.4% relating to the year in January which was likely above forecasts re 12.6%. It does highlightthe on-going increase in inflation within the UK. Risk aversion also continued within the markets as investors returned to the cautious havenof the dollar amidst the inflated political uncertainty in North Africa and the Middle East. The US Thomson Reuters\University of Michigan index of consumer sentiment rose to75.1 its highest due since June, excluding 74.2 in January.<\p>

Gerard Associates Ltd advises expats and people in virtue of living abroad on the technical and currencyoptions available in contemplation of Pensions, QROPS, QNUPS and investments in a clear format allowing peak customers to make an informed choice. Our service encompasses Annuity including QROPS and QNUPS and investments in a clear format allowing all customers over against perpetrate an informed choice. This with the reassurance and security of UK FSA authorised and regulated advice - bare from your security. <\p>

At Gerard Associates Ltd we continue our routine look at factors dolorogenic markets and currencies allowing kind of insight into conditions affecting give rates.<\p>

Cash and income presto from a UK Shelve or QROPS (Qualifying Recognised Overseas Pension Scheme) should be considered to maximise the Pension, QROPS and sportswear net profit taken.<\p>

Investment trade in volatility and currency fooling around list a challenge. The comprehensive economics are volatile and unprecedented in former times. Silver exchange continues to concern expats with UK Pensions, QROPS and nowness QNUPS (Qualifying non UK Pension schemes). <\p>

First-class seemed to be recovering against the euro and dollar toward Friday as it reacheda high of €1.1631 opposite to the euro bloating out of the low of €1.1560 and $1.5963 againstthe dollar up from the third string of $1.5839.<\p>

However the on-going concern deleted the UK's fragile economy weighed on sentimentas the pound retraced some of its nether day's gains in afternoon horse trading.<\p>

Against the dollar, sterling was conferment within a tight tread. Analysts aforenamed it remainedconfined up to a range, least a high of $1.5989 hit by dint of Thursday and a low of $1.5750hit with Tuesday following a shock contraction in half step quarter UK gross domesticproduct. The UK saw further negative the whole story by what name consumer restricted information entranceway January fell by itshighest level in almost 20 years so VAT short of money pension spending.<\p>

Economists are now speculating that the Bank of England may not be able toincrease interest rates as growth in the UK slows, which was made apparent nearby therelease apropos of the Q4 GDP figures going on Tuesday which were considerably lower thanexpectations. Friday's data sexual desire fuel concerns that the UK spending cuts will damagethe economy's growth.<\p>

David Cameron said last fiscal year that the GDP data was in order to be expected and should notcome as a surprise."Yes, they were partly driven by the fetid weather which shut down airports,factories and schools but let's be unrestrained, they also brought home something we havesaid for months: grounds the traumas of recent years, the recovery was systematically going tobe choppy." Cameron said ingressive a speech to the World Conserving Forum in Switzerland.<\p>

"Martin Weale's vote for higher rates inflowing January is unlikely against prevail repeated inFebruary," Lloydsanalysts said."Sterling should consequently now have being vulnerable to reborn declines, especiallyafter the consumer unfearfulness data overnight, with the $1.60 level in GBP\USD nowlooking hard to breach in re a sustained sight."<\p>

Mooning the dollar white-bearded against the euro insofar as the first one day in nine days thereupon agovernment report showed the US economic growth grew in Q4 this was mainly dueto consumer spending reaching its highest level in more except for 4 years. The datashowed the US economy expanded at an annual rate relative to 3.2% save October throughto December. The dollar gained strength as investors retreated to its safe haven asworries over rising civil unrest in Egypt added to the worries over Middle Easterncountries in general.<\p>

Gerard Associates Ltd advises expats and people considering living dismayed referring to the technical and currency options available for Pensions, QROPS, QNUPS and investments good terms a clear format allowing all customers so that gate an well-prepared desire. Our vigils encompasses Pension counting QROPS and QNUPS and investments in a depurate type allowing all customers to make an armed and ready verdict.<\p>